var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: The query time of the records from a foxpro Database is unusually high
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.