Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Major Index bogdown! HELP!
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00177210
Message ID:
00177248
Views:
42
Thanks for your reply, Christof!

Yes, I made sure all is optimized, DELETED() tags, etc... We do not use a filter or FOR clause, just simple SEEK's, followed by a DO WHILE x=y type of loop (to process all that match the SEEK). When you say close & reopen all tables, do you mean before the whole process, or at certain intervals within?
Thanks again!
Mark

>How do you process the table? Are you sure it's 100% Rushmore optimizable, ie. is there an index on DELETED(), do the index expressions match EXACTLY the one used in the filter or FOR clause, does the COLLATE sequence match?
>
>Sometimes, when you modify a lot of records in a loop, it helps to close all tables and open them again.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform