Right now there are two methods to empty a table: TRUNCATE and DELETE.
Both of them have advantanges and disadvantages, DELETE is slow on big tables and TRUNCATE can be slow too:
https://jira.mariadb.org/browse/MDEV-9459
So for the time being (eg. until the bug is fixed) it would therefore be nice if XenForo could natively support a 3rd Option: Recreate.
This would work by creating a new table based on the structure of the existing table, renaming the existing table and dropping the renamed table afterwards.
Both of them have advantanges and disadvantages, DELETE is slow on big tables and TRUNCATE can be slow too:
https://jira.mariadb.org/browse/MDEV-9459
So for the time being (eg. until the bug is fixed) it would therefore be nice if XenForo could natively support a 3rd Option: Recreate.
This would work by creating a new table based on the structure of the existing table, renaming the existing table and dropping the renamed table afterwards.
Upvote
0
