4 ms·
if I understand you correctly, this type of thing is implemented by partitioning by hour in a day and then having a janitor process drop tables that are older t
by keithgabryelski 12y ago
if I understand you correctly, this type of thing is implemented by partitioning by hour in a day and then having a janitor process drop tables that are older than 24 hours.
- morgo 12y agoALTER TABLE .. TRUNCATE PARTITION should be much faster than deleting as well. At least it is in MySQL.