Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Major Index bogdown! HELP!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00177210
Message ID:
00177248
Vues:
40
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform