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:

Re: SQL Connections ( Larry Hewitt 2004)
Re: SQL Connections ( Brian Fries 2004)
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.- 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!

Re: SQL Connections

2004

Top Articles:

Related Readings: