Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fastest way to check memo field for a string
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01410639
Message ID:
01410669
Vues:
37
>>>>I just tested this a few times and switched the order around. It appears you are correct. While the time changes depending on whether it is first, 2nd, 3rd, etc in the order (OCCURS() versus $ etc), $ does seem to be consistently the fastest.
>>>
>>>In Boris tests OCCURS() was the winner over $.
>>
>>:-)
>>No way!
>>
>>? [$], SECONDS()-m1                   && 0.045
>>? [OCCURS], SECONDS()-m1       && 0.284
>>
>
>Yes, now I see that I misread. You're right, $ is the fastest here in native functions.
>
>I was thinking we may try API solution, but when I was ready to research I was interrupted. But we repaired tables using CmRepair - it was my first time trying it.


And HOW I could UPDATE my previous reply to you when I get answer to it?
(Because I just saw what is the quotation to my answer and what is the updated one :o)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform