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:

[WebDNA] Is there a good file upload script available these days? (2009) [URL] and [showif] or [hideif] comparisons (2003) RE: [WebDNA] Webstar (2008) why .HTML pages no processing? (2000) ShrPAUL1@aol.com has been banned (2000) Major Security Hole (solution with Welcome) (1998) The IBC root beer has arrived! (1997) Tab Delimited Files / FM Pro (1997) suffix mapping, use of cache, etc. (1997) Something wrong with this list? (2006) vs (1997) Re:2nd WebCatalog2 Feature Request (1996) Big Databases (1997) I am sorry for always being such an ass (2004) test (1998) Request for improvement... (2002) Can't use old cart file (was One more try) (1997) Command=Showcart? (2000) 3.0 [TEXT] variables (1998) WebCat2 beta 11 - new prefs ... (1997)