Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › as › Reply To: as
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.