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.- BrianOn 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:
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.- BrianOn 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)