>>Is your table on a network drive ?
>>This could have a huge impact depending on network traffic...
>>I just tried a simple query on a table with over 1,000,000 records
>>and it took close to 15 seconds (on the network, with maybe 50 users having
>>the table opened at the moment) so maybe your 5-7 seconds
>>is not so bad :)
>
>Yup. Netware. The bandwidth is quite good, and there are probably 5 people with the table open at the moment. It sounds like this is query time is normal. Thanks for your help.
Evan- how fast are SEEKs on the table? I have a 4.5 million record table that gives subsecond SEEK times.
I would definitely try reindexing. This makes a big difference in my experience on tables that see a lot of action.
Erik Moore
Clientelligence