• Resolved concerto789

    (@concerto789)


    Jesus your plugin is so aweful !!!

    Too many ‘LIKE’ queries cause the database to crash,the plugin code is shit !!!

    Tell your developer to optimize it:

    $size_chart_args['meta_query'][] = array(
        'key'     => 'prod-chart',
        'value'   => "{$size_chart_id}",
        'compare' => 'EXISTS',
    );
    $size_chart_args['meta_query'][] = array(
        'key'     => 'prod-chart',
        'value'   => $size_chart_id,
        'compare' => 'LIKE',
    );
    $size_chart_args['meta_query'][] = array(
        'key'     => 'prod-chart',
        'value'   => "[{$size_chart_id},",
        'compare' => 'LIKE',
    );
    $size_chart_args['meta_query'][] = array(
        'key'     => 'prod-chart',
        'value'   => ",{$size_chart_id},",
        'compare' => 'LIKE',
    );
    $size_chart_args['meta_query'][] = array(
        'key'     => 'prod-chart',
        'value'   => ",{$size_chart_id}]",
        'compare' => 'LIKE',
    );
    $size_chart_args['meta_query'][] = array(
        'key'     => 'prod-chart',
        'value'   => "[{$size_chart_id}]",
        'compare' => 'LIKE',
    );
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Hitendra Chopda

    (@hitendra-chopda)

    Hello Concerto,

    Thanks for reaching out to us and for your attention.

    Sure, we will look into this and optimize the query as possible.

    Can you please share the below details to trouble your crash query?

    1. How many products do you have in your store?

    2. How many size charts are created?

    So, we can reproduce the issue from our end.

    Best Regards,
    Hitendra & Dotstore Team

    Thread Starter concerto789

    (@concerto789)

    1. 4730 products
    2. 3983 size charts

    Besides,some size charts assigned two or more products.

    There is a solution for you:
    Step1. Update the different format data in database to one same format.
    Step2. I suggest that use comma “,” to separate ID instead of “[” or “]”
    Step3. Optimize your code, DON’T use such many ‘LIKE’, PLEASE !!!

    Plugin Support Hitendra Chopda

    (@hitendra-chopda)

    Hello Concerto,

    Thanks for your feedback and for sharing the details.

    Okay sure, we will look into your feedback and optimize the code.

    Best Regards,
    Hitendra & Dotstore Team

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can’t edit size chart !!! Plugin code is shit !’ is closed to new replies.