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

Reply To: Indices disappear after database migration

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Indices disappear after database migration Reply To: Indices disappear after database migration

#41868
Ernest MarcinkoErnest Marcinko
Keymaster

That could indicate a database related issue then. Just to be sure, check if the index table is indeed enabled.

I strongly suggest running a database repair and table optimize queries on the whole database to make sure the data was correctly imported and it’s not fragmented. 15 million rows is a lot, but not tragic. Fragmentation can cause a huge memory issue with the actual table index structure on the database level.
I would also suggest looking at the server memory and space usage, just to make sure it has enough resources.