Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Speed Up Access Queries From ASP

Tables and Relationships

Speed Up Access Queries From ASP

by  RushiShroff  Posted    (Edited  )
You could:
1) Make sure that your data is correctly indexed (that does NOT mean that ALL fields need indices as they will slow down inserts/amends).
2) Make sure that your data is properly normalised.
3) Make sure that you open your recordsets at the last moment and close them as soon as possible.
4) Make sure that you only select relevant data.
5) Use paging.
6) Repair & compact the database.
7) Check the joins in your queries.
8) Get more RAM for your server.
9) Upgrade to SQL Server.
10) If you can't afford SQL Server, try MySql - it's free!
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top