General information
Category:
Coding, syntax & commands
>>>I just completed running a test using the Deleted()
>>>Index tag. I created 2 Identical Tables of about
>>>1.7 Million records, one with the deleted() Tag and
>>>one without.
>>>
>>>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
>>
>>When you say "with Deleted() tag", does that mean you SET INDEX TO deleted, or that you have an index on deleted()?
>>
>>The same for "without": you didn't set the order to that index or such an index doesn't exist?
>>
>>Vlad
>
>
>I mean there is an index for the 'with' and not an index for 'without'.
>
>These tables currently have no deleted records, I guess that makes the
>difference. I will randomly delete some records and test again.
Also:
Don't set any current order and quit&reopen VFP between any 2 tests.
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