Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First query of view very slow
Message
De
27/09/2004 11:30:18
 
 
À
27/09/2004 11:25:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00945788
Message ID:
00946288
Vues:
33
>>>>> snipped
>>>
>>
>>How much time demands one direct opening and scan?:
>>
>>t1=seconds()
>>USE tacust SHARED
>>? 'open header',seconds()-t1
>>t1=seconds()
>>scan
>>endscan
>>? 'first scan',seconds()-t1
>>t1=seconds()
>>scan
>>endscan
>>? 'second scan',seconds()-t1
>>
>
>Good morning Fabio,
>
>Open header took .65 seconds.
>First scan took 132.74 seconds.
>Second scan took 44.95 seconds.
>Third scan took 26.4 seconds.
>
>Re-ran 2nd time
>Open header took .21 seconds.
>First scan took 17.59 seconds.
>Second scan took 11.58 seconds.
>Third scan took 8.64 seconds.
>
>Hmm...

Interesting, the third time, the open file & scans each took less than a second.
Thanks!
~d
J
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform