|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 11th, 2005, 09:26 AM
|
||||
|
||||
|
MySQL Connection advice/opinion
I'm working on a mySQL database with my new site, just wondering which method you all find to work the best as far as performance and what not. This will be my first experience working with mySQL so I'm hoping it will be a good one
 JMH
__________________
jmurrayhead Did I help you out? Make me popular by clicking the  icon!New Members:Proper way to post a question Powered by ASP.Net
|
|
#2
December 11th, 2005, 01:43 PM
|
||||
|
||||
|
if you have any experience with databases, then MySQL is not so different -
only different syntax for the SQL statements. as for performence, watch carefully to Close all connections and recordsets and also deal with all the connection stuff in one single include file. if you're really into it, build your own SQL-building methods: different methods for Selecting, Updating and Inserting Into tables - all generic.
|
|
#3
December 11th, 2005, 02:20 PM
|
||||
|
||||
|
Quote:
Thanks for the input, so far it looks like I'm on the right track. Which connection method do you prefer?
|
|
#4
December 11th, 2005, 06:48 PM
|
||||
|
||||
|
Quote:
Code:
Set objRS = objConn.Execute(strSQL) 
|
|
#5
December 11th, 2005, 07:54 PM
|
||||
|
||||
|
Quote:
awesome, looks like I'm doing everything right.
|
|
#6
December 18th, 2005, 03:00 AM
|
||||
|
||||
|
Quote:
http://forums.aspfree.com/asp-free-...d-65858-48.html congrats JMH, let us know if you need any further advice!
|
|
| Viewing: ASP Free Forums > Other > ASP Free Lounge > MySQL Connection advice/opinion |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
