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:
01004726
Vues:
38
>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 may have been wrong in my first test. I probably have RIDefinitions table opened already... With this table closed I don't see a speed improvement but rather degradation... Also I'm trying to understand this clUSE_AGAIN business.

BTW, check your e-mail as well and UT private :)
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