Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing dbf file updating help
Message
From
01/03/1999 21:24:02
 
 
To
01/03/1999 21:11:48
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00192969
Message ID:
00192977
Views:
21
>Hi,
>
>I had a application using SEEK 'key' and then update it records
>using REPLACE .. WITH becoz it help to update any old records if I repost my data file again. It is great that it prevent any duplicate
>records in my data file, but the searching by SEEK and then replacing it is slow as my data file and index file get big.
>
>Any one had any good ideal or suggestions or advise to assist me in
>speeding it up or any good code to share with me. Thank a lot

You won't get any faster than SEEK(). Do you have an index on DELETED()?
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform