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=conn1Does 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.TIALarryLarry Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX109 No. Tower360.880.4855 CELLP.O. Box 1017larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.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:
In the WebDNA documentation, the SQLConnect connection variable is set as a text value; ex: conn_var=conn1Does 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.TIALarryLarry Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX109 No. Tower360.880.4855 CELLP.O. Box 1017larryh@hewittco.comCentralia, WA 98531www.votewashington.orgwww.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:
Bad Cookie / Internet Option / Internet Explorer (2004)
date search not working when type=date specified (2007)
minimalist shopping cart. (1997)
credit card authorization question (1997)
HELP WITH DATES (1997)
One per customer (2000)
Assigning new CART number (1997)
Sorting Numbers (1997)
Three new problems, maybe a fourth (1997)
Emailer prefs in two places ... (1997)
[shownext] support - MacOS (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Deleting Orders (1997)
SiteEdit NewFile.html ? (1997)
WebCat2 several catalogs? (1997)
[BULK] Fwd: [WebDNA] [BULK] WebDNA discovery in the Console - [having many crashes] (2011)
setitems, one more thing (1997)
French characters in variables (2001)
Help formatting search results w/ table (1997)
Re:listfiles-looking for slick solution (1997)