Support » Plugin: WooCommerce PDF Invoices » Slow query with unprocessed WC orders

  • compupower

    (@compupower)


    Hi Bas,

    First of all, thanks for your plugin.

    We’ve encountered a problem, however, which causes the single order pages in the WP dashboard to be slow, when the order status is “Processing” or “In behandeling”. According to the Query Monitor plugin, this is being caused by a slow database query that is executed by this plugin, as can be seen in the following screenshot:

    https://vallonic.com/wp-content/uploads/2019/06/Screenshot-2019-06-18-at-10.03.30.png

    Do you have any advice on how to speed this query up? Maybe you could cache the highest invoice number in a transient instead.

    By the way, it is indeed a large WooCommerce website with approx. 2500 orders stored. The slow query only affects the loading of an order that hasn’t been completed yet.

    It’d be great if you could help us out here!

    Thanks in advance.

    Thierry

    • This topic was modified 2 months ago by  compupower.
  • You must be logged in to reply to this topic.