Re: MySQL question

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 60695
interpreted = N
texte = There is no need to change the conn_var name. The SQL connections are =not 'shared' across all requests, each WebDNA request thread maintains =its own list of SQL connections.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfLarry HewittSent: Friday, January 07, 2005 09:24 AMTo: WebDNA TalkSubject: MySQL questionWe just ran our last election successfully on the new VoteWashington =20version we converted to MySQL. While we had very good results, I have =20a nagging question I need to ask before i go forward with our next =20upgrade.The SQL Connect statement:[SQLConnect =20dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D[pwd]&conn=_var=3Dconn=201]Is there a benefit to changing the value of the 'conn_var' parameter. =20I currently use the same one throughout, so for every connection made =20across all the users it is the same. I have not had any indication =20this would have an impact on performance, given the short nature of the =WEBDNA based SQL call, but I have no way to know for sure.Advice from those more experienced with this would be appreciated.LarryLarry Hewitt360.807.1100 OFFICEHCO, LLC 360.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/-------------------------------------------------------------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: WebDNA - mySQL Questions ( John Peacock 2005) WebDNA - mySQL Questions ( "Christian F. Gurney" 2005) Re: MySQL question ( "Scott Anderson" 2005) MySQL question ( Larry Hewitt 2005)

There is no need to change the conn_var name. The SQL connections are =not 'shared' across all requests, each WebDNA request thread maintains =its own list of SQL connections.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfLarry HewittSent: Friday, January 07, 2005 09:24 AMTo: WebDNA TalkSubject: MySQL questionWe just ran our last election successfully on the new VoteWashington =20version we converted to MySQL. While we had very good results, I have =20a nagging question I need to ask before i go forward with our next =20upgrade.The SQL Connect statement:[SQLConnect =20dbType=3DMySQL&host=3D[host]&database=3D[db]&uid=3D[uid]&pwd=3D[pwd]&conn=_var=3Dconn=201]Is there a benefit to changing the value of the 'conn_var' parameter. =20I currently use the same one throughout, so for every connection made =20across all the users it is the same. I have not had any indication =20this would have an impact on performance, given the short nature of the =WEBDNA based SQL call, but I have no way to know for sure.Advice from those more experienced with this would be appreciated.LarryLarry Hewitt360.807.1100 OFFICEHCO, LLC 360.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/-------------------------------------------------------------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/ "Scott Anderson"

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:

Shownext from POST (2000) Sort Order on a page search (1997) Pithy questions on webcommerce & siteedit (1997) searchable list archive (1997) Appending current [date] to a database (1997) Web Delivery Page concept (1997) Location of Browser Info.txt file (1997) how to set a new cart number periodically (1999) Any problems with Welcome & WebCat? (2000) [protect] on NT? (1997) Protect (1997) Sample Tearoom Search Error (1997) Refering page (1998) OT: PowerKey Pro 600 (2001) Re2: frames & carts (1997) Cumulative Shipping charge calculations - your help please. (1997) I give up!! (1997) WebDNA on Windows questions (2007) executing via commandline (2003) Webcatalog error, Plug-in for Webstar (1996)