>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.