Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleted Index Tag seems slower?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Deleted Index Tag seems slower?
Miscellaneous
Thread ID:
00052916
Message ID:
00052916
Views:
82
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

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!
Thanks,
Patrick

Senior Analyst/Programmer
Lexington, KY
(Basketball, Bourbon & Horses... What Else Matters?)
Next
Reply
Map
View

Click here to load this message in the networking platform