jclermont, 4 months ago Here are some considerations if you need to clean up a big table, without taking production down or even making it slow. #php #laravel https://masteringlaravel.io/daily/2024-01-24-considerations-when-cleaning-up-a-big-table
Here are some considerations if you need to clean up a big table, without taking production down or even making it slow. #php #laravel https://masteringlaravel.io/daily/2024-01-24-considerations-when-cleaning-up-a-big-table
michael, 4 months ago @jclermont Dropping and rebuilding the table seems like a sledgehammer approach. But if you do it, then at least rebuild it with partitioning so you can delete old data more easily next time: https://sqlfordevs.com/partition-delete-old-rows
@jclermont Dropping and rebuilding the table seems like a sledgehammer approach. But if you do it, then at least rebuild it with partitioning so you can delete old data more easily next time:
https://sqlfordevs.com/partition-delete-old-rows
Add comment