Since I am working with imported data via an API I have a huge amount of custom posts.
Your Search plugin can index all of that without a problem but the table nhvgy_asp_index became by far the biggest position in my database.
So i was thinking it might be a smart idea to maybe outsource this data to a second database which could then be even something better than sql and simmulate a saas solution in a way. That way the other database only pushes the current in nhvgy_asp_index saved data and the wordpress-database gets smaller and lighter and faster by a huge amount with such a solution.
I don’t think it is neccessary. MySQL or MariaDB can handle really big databases (multiple TB’s of data). The table size should not matter, until the indices are set right, and they are for sure. I googled a bit around, and most people generally have similar experiences.
Best, Ernest Marcinko If you like my products, don't forget to rate them on codecanyon :)