Forums › Forums › Search & Filter Pro › Problem with plugin crushing the hosting server

Viewing 6 posts - 1 through 6 (of 6 total)
  • Anonymous
    (Private)  July 15, 2015 at 9:35 pm #21500

    After trying to create filters using the plugin saving them via ajax and trying to input the search filter shortcode, my site broke down, the mysql service went up to 294% usage. and 20 consecutive queries where fired. Is the any problem with the plugin? I have many attributes in my woocommerce store. Too many attributes and variations does this matter?

    Ross Moderator
    (Private)  July 16, 2015 at 12:27 am #21507

    Hi Stelios

    You shouldn’t find high usage unless you are doing a lot with post meta/custom fields.

    What fields are you using, and roughly how large is your database? Taxonomies should be pretty fast (can you screenshot your search form for me?)

    I’ve actually implemented a caching system in S&F 2.0 which is out in testing at the moment, which should allow sites with all kinds of configurations to run smoothly – searching roughly 2000 posts with 40 filter options has tested to be working well and quickly with the next version.

    Let me know you thoughts, it might be worth setting you up the next version right away – if you are not using many meta fields, then there might be another problem completely – a link or some idea of your exact configuration would be useful.

    Thanks

    Anonymous
    (Private)  August 5, 2015 at 3:40 pm #22769
    This reply has been marked as private.
    Ross Moderator
    (Private)  August 5, 2015 at 4:19 pm #22777
    This reply has been marked as private.
    Ross Moderator
    (Private)  August 20, 2015 at 9:08 am #23461

    How is that working out for you?

    Anonymous
    (Private)  August 20, 2015 at 10:12 am #23463
    This reply has been marked as private.
  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)