This topic contains 1 reply, has 2 voices, and was last updated by Ernest Marcinko 3 years, 5 months ago.
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic.
Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › nhvgy_asp_index is growing immensely big – outsource to a second database maybe?
This topic contains 1 reply, has 2 voices, and was last updated by Ernest Marcinko 3 years, 5 months ago.
Hi there!
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.
What is your opinion on that?
Hi,
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,You must be logged in to reply to this topic.
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |