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:

mac hack (1997) calendar (2001) Cancel Subscription (1996) synching databases on multiple servers (1997) searching with groups (1997) Almost a there but..bye bye NetCloak (1997) Sendmail truncation in Eudora Clients (1998) mem leak: webcat (2001) Date sorting (1997) Loosing Quantity (2000) Text data with spaces in them... (1997) WebCat2_Mac RETURNs in .db (1997) Webcatalog 4.02b5 Mac OS X headers (2000) WebCatalog for guestbook ? (1997) Ampersand Character (&) (1997) Browser Problem?!? Still getting Error message using POST! (1997) [WebDNA] v7 Stress Test and Strange Behaviour (2012) WebCatalog for Postcards ? (1997) pc (1997) [WebDNA] (2010)