Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
 
 
À
14/04/2005 12:25:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01002645
Message ID:
01004729
Vues:
42
>Hi Nadya,
>
>>I just tried it. To replace value with 50000 records (the same value to the same value) it originally took 91 sec. and now it's 35 sec., with native RI is taking 51 sec. That's definitely a huge improvement.
>
>Well, that is nearly all for that approach: there are still a few ms hiding, but not enough to ferry out.
>But remember that I sent you this code cold: just visualizing the data flow for the RIDef-Table and some inspired line cutting. There is at least one lcTag undefined AFAIR... Not production quality yet ;-)
>
>Build a few test cases for other operations as well and keep me informed about the numbers. Also pls. check your company mail acount: don't worry, it is not a bill...
>
>regards
>
>thomas
I re-ran it again and now it takes 87 sec. for 50000 recs. Did I do something bad again? It's like 1 step forward and 2 backwards... :( And I hadn't yet tested everything in my test database.

I did a test with my TEST database first using yesterday's code. It took 13 sec. Then with today's code. It took 17 sec. I guess, I'm running in the wrong direction...
If it's not broken, fix it until it is.


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

Click here to load this message in the networking platform