Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First query of view very slow
Message
De
27/09/2004 13:29:41
 
 
À
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:
00946352
Vues:
15
>>>>> 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...


try this and post results:
* first time
t1=seconds()
USE tacust SHARED
SEEK 2^30 ORDER Tagcmrno
? seconds()-t1
? header()+recsize()*reccount()
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform