Performance Issues

  • Resolved beninverse

    (@beninverse)


    11 months, 3 weeks ago

    we have a site that is using sequential numbers pro. during an audit, we found that when a customer checks out, during the ajax request, a very long query occurs.

    for context, we have upwards of 600k orders.

    we added the performance mode filter. all that this did was slightly modify the query, but it took basically the same amount of time.

    is there any way to make this more performant?

    here is an example of the query (not in performance mode)
    INSERT INTO wp_6_postmeta (post_id,meta_key,meta_value) SELECT 648387,’_order_number’,IF(MAX(CAST(meta_value AS SIGNED)) IS NULL OR MAX(CAST(meta_value AS SIGNED)) < 3005240000, 3005240000, MAX(CAST(meta_value AS SIGNED))+1) FROM wp_6_postmeta WHERE meta_key=’_order_number’

    here is an example of the query (while in performance mode)
    SELECT MAX( CAST( meta_value AS SIGNED ) ) FROM wp_6_postmeta WHERE meta_key=’_order_number’

    — just an edit —

    i retried again and things were much faster. would it make sense that performance mode may run slowly on the first attempt?

    • This topic was modified 11 months, 3 weeks ago by beninverse.
    • This topic was modified 11 months, 3 weeks ago by beninverse.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Zach

    (@zachskyverge)

    11 months, 3 weeks ago

    Hello there @beninverse ,

    Thank you for reaching out about our plugin, Sequential Order Numbers! I’m happy to assist you with this. 🙂

    I see that you mentioned our Pro version. If using the Pro version, you will want to reach out to our support via your woocommerce.com account so we can fully assist with an issue. 🙂

    That said, I understand that you were seeing performance issues with the site and enabled the performance mode filter for Sequential Order Numbers Pro. The performance filter would be expected to speed up the process for order number generation for use when there are a high rate of orders being processed or a large amount of existing orders. Because information and queries maybe cached or in a temporary state, it is possible to not see a difference initially.

    Are you still seeing the performance boost from using the filter at this time?

    Best wishes,

    Thread Starter beninverse

    (@beninverse)

    11 months, 3 weeks ago

    if i go through the regular woo channel i have to do a whole bunch of garbage with the system report amongst other things.

    before i saw your response, i reviewed the code and saw that it would need to set a site option on first run, which makes sense why it was slow. subsequent attempts ran much faster.

    if you know of any potential problems with enabling performance mode, aside from the ability to start from deleted orders mentioned in the documentation, please let me know.

    thanks.

    Plugin Support Zach

    (@zachskyverge)

    11 months, 3 weeks ago

    Hi @beninverse ,

    Thanks for getting back to me on this! I understand. 🙂

    I am glad to hear that the performance has remained. There should not be anything else to be aware of aside from the deleted order numbers not being re-used. That said, if you do encounter any issues, feel free to reach back out!

    Best wishes,

    Thread Starter beninverse

    (@beninverse)

    11 months, 3 weeks ago

    thanks Zach. i appreciate the help. i don’t know if i can close this out, but feel free to do so.

    Plugin Support kaylaskyverge

    (@kaylaskyverge)

    11 months, 3 weeks ago

    Hey there,

    Thank you so much for getting back to us. I’m going to mark this topic as resolved per your request.

    If you’re still experiencing issues please take a look at our FAQs for more information and create a new thread if you have further questions.

    Thanks,
    Kayla 🙂

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Performance Issues’ is closed to new replies.