Delete database records, delete good or update? _ Application Tips

Personally, it's better to use update.
After some tests, it was found that almost all databases use the DELETE statement, the database file size does not become smaller, so that every time the database insert operation, the database volume will be larger.

Instead of deleting it, let him keep it. found that when using update, as long as the new data is not larger than the original, the size of the database will not increase (the file is stored to the database is very easy to see effect).

Therefore, it is recommended that you use the Update method to mark the deletion of records, and when you add a new record, update the record as a new record if there is a record marked for deletion. When you add a new record, the judgment is simple:

Copy Code code as follows:

Rs. Open "SELECT * FROM TableName where deleted=1 ORDER by ID ASC"
If Rs. EOF Then Rs. AddNew
RS (1). Value= "...";
'.....
Rs. Update

When we need to add new data, we first query for any data that is marked for deletion, if not (Rs. EOF), inserts a record (ADDNEW) or overwrites the new data to the first queried record.