Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pros and Cons of SQL vs DBF
Message
From
03/08/2003 13:54:33
 
 
To
03/08/2003 11:26:26
Mike Smith
Doncaster Office Services
Oakville, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00816294
Message ID:
00816316
Views:
16
Hi Mike,

on SQL you cannot RECALL DELETED records; SQL mark deleted records like empty space on file page, and it res-use part of this space automatically on internal garbage collection of file pages.

This is, normally, fast and little correlated to the number of record because the table isn't a table, but a b-tree clustered index.
Previous
Reply
Map
View

Click here to load this message in the networking platform