asked on

Need help on ADO connection with DBF file performace.

Dear all,

I've got a problem on ADO connection with foxpro dbf file. i use a udl file to point to the dbf file, that's fine. But the problem is the access is very slow, it use about 5 min to run a select statement, can someone throw me some light on how to improve the performace?

The dbf file is 700Mb and containing more than 600k row of data.
the connection is using:
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=PVoucher;UID=;SourceDB=c:\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"

i was told that the performance would be better if i use the seek/seek and replace method than the select/update method, is it true?

Thx in advance
Alpha

twalgrave

Seek and seek/replace would only be good once you have the records. If the problem is in connecting to the DB (it takes 5 minutes to connect), these won't help. Making sure you are only returning the records you want helps if the problem is in the retrieval of data,etc.

Alpha Au

ASKER

Dear, Thx for the reply, but the problem has been solved by adding index to the dbf.
thx anyway

twalgrave

please post a zero-point question in community support asking fo rthis question to be deleted and your points refunded. https://www.experts-exchange.com/Community_Support/

Remember to copy/psate this URL so they know which Q to work on. https://www.experts-exchange.com/questions/20510090/Need-help-on-ADO-connection-with-DBF-file-performace.html

Thanks

Alpha Au

ASKER

thx!

ASKER CERTIFIED SOLUTION