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;U
ID=;Source
DB=c:\;Sou
rceType=DB
F;Exclusiv
e=No;Backg
roundFetch
=Yes;Colla
te=Machine
;Null=Yes;
Deleted=Ye
s;"
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
Start Free Trial
