Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First query of view very slow
Message
From
27/09/2004 11:30:18
 
 
To
27/09/2004 11:25:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00945788
Message ID:
00946288
Views:
34
>>>>> 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
Previous
Reply
Map
View

Click here to load this message in the networking platform