The query time of the records from a foxpro Database is unusually high
over a LAN of 10mbps.

1. I have a foxpro Db on a machine with 100000 records. I have several clients trying to access this database over a LAN of 10mbps.

2. The fields in the foxpro database are indexed

3. When i try to Access the Database using ADODB.Recordset

ex: ORS.Open sqlQuery,ADODB.Connection,....,....

The time taken for results to comeback to client is very high(45 secs),
but if i run the same query again without disconnecting from database
it takes less than 2secs.

Any Ideas???