SQL Connections

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59374
interpreted = N
texte = 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 Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- 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)
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 Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- 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/ Larry Hewitt

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:

Two prices in shoppingcart? (1997) Showif, Hideif reverse logic ? (1997) Looking up two prices in database? (1997) Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997) WCS Newbie question (1997) Using [purchase] (1998) ConvertChars (2000) [WebDNA] Ubuntu 14.04 & WebDNA (2017) Bug? (1997) Problems passing [SKU] with $Replace in 2.0 (1997) &fieldsdir=ra truely random?? (2000) WebTV (1998) [WebDNA] WebDNA-folder-Mac-FastCGI-8.5.1.zip (404 error) (2018) Remove a Field from a DB (2007) Error.html (1997) Does anyone have a solution to make carts smaller? (1998) [shownext] and sort (1998) RE: storefront (1998) OT: New Virus? (2001) MacWEEK article help needed (1996)