General information
Category:
Coding, syntax & commands
>>I ran a series of identical queries and below are the results:
>>
>> With Deleted() Tag Avg of 24.4152 Seconds
>>Without Deleted() Tag Avg of 16.5155 Seconds
>>
>>And yes set deleted is ON.
>>
>>Note: SYS(3054) Returns Full optimization on "With Deleted Tag"
>> and Partial Optimization on "Without Deleted Tag".
>>
>>Go Figure!
>Patrick,
>
>That is strange. I just ran tests also, after reading your message and here's the results I got with SET DELETED ON and 107 deleted records in a table with 1,072,071 records. The select was a simple single table select and was done 5 times each with the times averaged;
>
> Without tag on deleted(): 42.02 seconds
> With tag on deleted(): 0.39 seconds
>
>This is a very different result than you got. The machine these tests were run on is running WinNT 4.0 SP3, a P166 with 48MB of RAM, nothing else running, no network connection, adn also this was with VFP 5.0a with SP2 from VS applied.
>
>My results show that no tag on deleted is approximately 107 times slower than with a deleted tag.
Do you close and reopen VFP between any 2 SELECTs? VFP optimizes SELECTs from one to another if possible.
Vlad
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only