Forums › Forums › Search & Filter Pro › Performance issue due to many wp_postmeta records

Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Anonymous
    (Private)  March 13, 2020 at 1:32 am #236554

    Hello,

    We are running Tennis website with WordPress.
    https://tennisnavi.jp/match/

    We have used ACF for some custom post types and “Search and Filter Pro” for our visitors to search Tennis match information.
    However, we recently experienced performance issues as we think wp_postmeta table becomes huge (more than 1.5 million records!).

    We think “ACF Custom Database Tables”(https://hookturn.io/downloads/acf-custom-database-tables/) might be a good option to solve the performance issue. But our concern is whether we can keep using “Search and Filter Pro plugin”.

    Do you have any thought on this?
    If you have another good idea to solve the performance issue, it would be really helpful.

    Thanks,
    Taishi

    Trevor
    (Private)  March 13, 2020 at 6:19 am #236567

    Our plugin requires that such data is held in the postmeta table, sorry. How many posts do you have? And how many are you adding each month?

    Anonymous
    (Private)  March 13, 2020 at 6:38 am #236577

    Thanks for your reply.

    We have approximate 10,000 posts in total at this moment. We are adding 1,000 posts per months but also delete similar number of posts, so the total number of posts will not change so much.

    Trevor
    (Private)  March 13, 2020 at 6:45 am #236581

    That should be OK within the bounds of performance for our plugin.

    If speed is the issue, then you might need to investigate server performance as the issue, specifically database read and writes.

    You might, for example, see if you can add Elasticsearch to the server. This thread discusses this:

    https://support.searchandfilter.com/forums/topic/working-with-elasticpress-elasticsearch/

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)