Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any way to speed it up?
Message
 
 
À
10/01/2006 03:33:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01084765
Message ID:
01085115
Vues:
15
>Naomi,
>If you have correct indexes, then
> the problem is in the backstage.
>Have you RI code that is performed ?

I re-indexed all tables yesterday and I switched from UPDATE to REPLACE WHILE. I have lots of RI, but they are executed only when I'm doing tableupdate (and that's why my tableupdate took ~ 1min. for 15K records in ~7 tables). The total execution time is now down to ~4 minutes for 15K records, which I think is good enough and can be accepted.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform