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

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