General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
David,
So would it be wise to leave some deleted records in the tables? Something like IF SELECT FOR DELETED() > some value then recycle??
Thanks
>John,
>
>>Thanks for the reply. I am much more inclined to have one approach to keep up with.
>>
>>I worked out an approch to recycling records see my reply to Rick. If I missed anything please let me know.
>
>Just check query performance carefully with full-size tables with a usual mix of deleted and live records (see my reply to Rick). If you will have lots of deleted records, the performance penalty of DELETED() tag may not apply.
Previous
Next
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