Lack of interest 3rd Method for emptyTable()

This suggestion has been closed automatically because it did not receive enough votes over an extended period of time. If you wish to see this, please search for an open suggestion and, if you don't find any, post a new one.
K

Kirby

Well-known member
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.
 
Upvote 0
This suggestion has been closed. Votes are no longer accepted.

Similar threads

JoyFreak
  • Question Question
XF 2.2 "This is the abstract init method for XF.Element, which should be overridden."
Replies
1
Views
391
JoyFreak
JoyFreak
Liam W
  • Suggestion Suggestion
Lack of interest No method for marking column 'first'.
Replies
1
Views
646
Chris D
Chris D
DragonByte Tech
  • Suggestion Suggestion
Lack of interest [Developer Tool] Method for applying custom formatting for Statistics
Replies
0
Views
564
DragonByte Tech
DragonByte Tech
X
  • Suggestion Suggestion
Lack of interest Expose standard method for add-ons installers to recommend CLI upgrade/install
Replies
0
Views
791
Xon
X
LPH
Best Method for checking existence of thread_id
Replies
12
Views
1K
LPH
LPH
Back
Top Bottom