Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select alltrim(lname) is 10x longer than select lname
Message
De
17/08/2006 11:13:22
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
17/08/2006 10:55:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
SAMBA Server
Database:
Visual FoxPro
Divers
Thread ID:
01146381
Message ID:
01146401
Vues:
18
>Sergey, you are absolutely correct - there is now no time difference. Unfortunately, the time is now the longer of the two times. now:
>
>select lname, fname from table1 into cursor cursor1 nofilter
>
>takes about 4 seconds. without the nofilter, the above statement only took 0.4 seconds.
>
>consistency is great but i'm hoping for consistently good! :-)

It's not just the query. Check the time required to populate your combo box with and without NOFILTER.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform