Hmmm well if it's timing out visitors aren't going to be hanging round.
You can apply general rules for database efficiency, but without seeing
your code it's hard to tell if your script is utilising the database
efficiently enough or not. If it is, consider an upgrade to an
SQL Server Database (I am assuming you are using Access), or if this
does not help get on a better server.
Anyway, for faster database access:
- Only call fields from the database once
For example, don't keep doing rs("field"), when you open the record set
put it in a variable then reference the variable for the rest of the
script
- Only select what you need
Dont do SELECT * in your SQL query, select the field names you are pulling
- Read up on SQL
Often there are scripts using multiple recordsets and querys when
infact they can sometimes be compacted into more complex single queries
that are more effieicient. Look on w3schools.com for tutorials.
- Close your objects
Make sure you close and drop all your database objects as soon as you don't need them
Hope this helped
Topic Options
Post Options
Thanks(0)
