Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improving sluggish SQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00306158
Message ID:
00306386
Views:
44
>And what about the RECALL ALL vs optimistic table buffering and TABLEREVERT()? That's where I expected to see a significant difference in performance.

Er, I never got that far in testing, since the DELETE method was already known to be slower in total at that point than the NOT IN method...

RECALL was *very* slow though, in the one time I applied it to recover the DELETEDs from the above testing...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform