Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
 
 
À
14/04/2005 00:51:35
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:
01004664
Vues:
40
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.

Let me check various conditions and if nothing fails I owe you big < g >

>Hi Nadya,
>
>I am getting more doubtful on the validity of my previous assumption:
>Is the "Currentrecord" in RIDefinitions guaranteed to stay even when triggers maybe call RI recursively inside each function ?
>Since RIDefinitions is always used as alias and the recordponter insn't saved/reset,
>any recursion could be dangerous to the correct coverage of the scan-loops.
>
>Check the out the following (mostly done as finger flexing while waiting for another nachine to finish processing -
>neither checked nor guaranteed - use to get ideas or at you own risk <g>), especially check the parts with cL_USE_AGAIN...
>
>Hopefully worth more than you paid for it ;-)
>
>regards
>
>thomas
>
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