This website uses cookies to personalize your experience. By using this website you agree to our cookie policy.

Reply To: as

#22555
Ernest MarcinkoErnest Marcinko
Keymaster

Hi,

You did okay, as the row count got significantly lower there. That size could be fragmented or maybe there is a database cache there in effect. If you use PHPMyAdmin or any similar tool, there should be a table optimize and flush feature built in, that should defragment and clear the database cache: https://i.imgur.com/nnq3HtP.png

Try running those three, but please be careful. Make sure to have a full database back-up before running those commands. They might take a few minutes to execute. If there was any fragmentation, the table size should definitely decrease.

I’m not sure how much reduction you can expect there, that table size with over 2 million rows of information sounds about right to me.