Re: SQL Connections

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59376
interpreted = N
texte = Larry - From what I understand, the variable name needs to be unique within the page, unless you do a [sqldisconnect] to free up that variable for reuse in a new connection. WebDNA automatically does the disconnect when the page ends. I don't know if it would cause problems to use the same variable name in multiple pages being executed at the same time in different threads. You could use a variable named "c[cart]" or something similar to ensure uniqueness. - Brian On Sep 15, 2004, at 8:55 AM, Larry Hewitt wrote: > In the WebDNA documentation, the SQLConnect connection variable is set > as a text value; ex: conn_var=conn1 > > Does this have to be unique; is it better to assign a variable name > going in (see beloe) so that conenctins have different values. It > appears that MySQL handles multiple instances of "conn1" OK, but I was > having issues last night with TOO MANY CONNECTIONS on our election > primary night. > > Normally, it appears to be able to drop the connection quickly. We > had an instance where the graphics server we use from our ISP was > malfunctioning, and it appears that the pages loading so slowly > causing the number of SQL connections to remain high, then max out. > > Is it an issue of number of max connections, or too many instances of > a particular connection? > > I have a routine to create a random variable > [text]conn1=[random][random][/text] > then use [conn1] as the connection variable - resulting in a highly > likely unique ID. But today the server is working fine the way it > was. > > Any one with experience with this would be helpful - we are breaking > our teeth in on SQL. More plusses than minuses at this point. > > TIA > > Larry ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL Connections ( Larry Hewitt 2004)
  2. Re: SQL Connections ( Brian Fries 2004)
  3. SQL Connections ( Larry Hewitt 2004)
Larry - From what I understand, the variable name needs to be unique within the page, unless you do a [SQLdisconnect] to free up that variable for reuse in a new connection. WebDNA automatically does the disconnect when the page ends. I don't know if it would cause problems to use the same variable name in multiple pages being executed at the same time in different threads. You could use a variable named "c[cart]" or something similar to ensure uniqueness. - Brian On Sep 15, 2004, at 8:55 AM, Larry Hewitt wrote: > In the WebDNA documentation, the SQLConnect connection variable is set > as a text value; ex: conn_var=conn1 > > Does this have to be unique; is it better to assign a variable name > going in (see beloe) so that conenctins have different values. It > appears that MySQL handles multiple instances of "conn1" OK, but I was > having issues last night with TOO MANY CONNECTIONS on our election > primary night. > > Normally, it appears to be able to drop the connection quickly. We > had an instance where the graphics server we use from our ISP was > malfunctioning, and it appears that the pages loading so slowly > causing the number of SQL connections to remain high, then max out. > > Is it an issue of number of max connections, or too many instances of > a particular connection? > > I have a routine to create a random variable > [text]conn1=[random][random][/text] > then use [conn1] as the connection variable - resulting in a highly > likely unique ID. But today the server is working fine the way it > was. > > Any one with experience with this would be helpful - we are breaking > our teeth in on SQL. More plusses than minuses at this point. > > TIA > > Larry ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Brian Fries

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Username/Password with [Protect] (2000) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Re:2nd WebCatalog2 Feature Request (1996) Credit Card Gateways (2005) v6 Development copy download link seems to be offline? (2004) WebCat2: Items xx to xx shown, etc. (1997) WCS Newbie question (1997) What am I missing (1997) read and write you own cookies with webcat (1997) hiding return characters (2000) PIXO Support (1997) email program problem (1998) WebCatalog 3 manual (1998) Tip: upgrading to WebCatalog 3.x, fields to watch for (1999) Customer (1998) Searchable mail archive problems (2003) Cart Numbers (1997) Location of Browser Info.txt file (1997) founditems / writefile (2005) [index] (1997)