p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Access performance problem.


Message #1 by gbrown@c... on Mon, 24 Jun 2002 10:55:07
Hi all

This is going to seem like a very basic question but here goes anyway!

I have an Access MDB with a table containing approx 500,000 records.
In ASP I then do a select top 10 *. The recordset is forward only so any 
ideas why this takes about a minute to run?

I am probably going to move to either MSDE or SQL Server soon but would 
like to know how far I can push Access.

Regards
Graham
Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Mon, 24 Jun 2002 18:32:20 +0200
Hi Graham,

Here are some ideas for how you can optimize your queries:
http://www.advent-it.co.uk/queryop.html

-Kim



> -----Original Message-----
> From: gbrown@c... [mailto:gbrown@c...]
> Sent: 24. juni 2002 10:55
> To: ASP Databases
> Subject: [asp_databases] Access performance problem.
> 
> 
> Hi all
> 
> This is going to seem like a very basic question but here goes anyway!
> 
> I have an Access MDB with a table containing approx 500,000 records.
> In ASP I then do a select top 10 *. The recordset is forward only so any 
> ideas why this takes about a minute to run?
> 
> I am probably going to move to either MSDE or SQL Server soon but would 
> like to know how far I can push Access.
> 
> Regards
> Graham

  Return to Index