ATUM’s impact on the performance of Orders

Hi @ibrahimoo

Are you using any ATUM premium add-ons (mainly Multi-Inventory or Product Levels)?
Depending on your specific configuration and data and also on the installed plugins, there are many operations that could be needed to be done in the background (in order to adjust the stocks correctly). But ATUM alone (the free plugin) does not perform any action when you process a WC order.

Best Regards,
Salva.

Hi @salvamb

Thanks for your response.

The client I’m working for has MI add-on, it is installed (uploaded) but NOT activated (due to this issue).

For the second part of your answer, the performance remains acceptable (~30%) with the current configuration and plugins. So the concern is why it’s deteriorated once ATUM is activated back.

I appreciate your thoughts on this issue.

Many thanks in advance for your kind support.
Ibrahim

Hi @ibrahimoo

Sorry, it’s not clear. Did you disable ATUM or MI or both?
Does this happen only with ATUM and with MI disabled?

Hi @salvamb,

All what I’ve mentioned at the begining in my first message happened while MI add-on is disabled (all the time).
Now for the ATUM free plugin, these are the findings of the testing:
* ATUM is inactive: CPU usage 30%
* ATUM is activated: CPU usage 97%

Please let me know if you need any further details.
Thanks for your support.
Ibrahim

Thanks for the clarification.
So, the only thing that could happen in the background (only with ATUM) when an order is processed is the props we need to calculate when an order is created/updated (like Sales last days, Stock will last, lost sales, etc). If you don’t need any of this information in your Stock Central, I could give you some hints in order to disable the calculations when an order is processed.

Best Regards,
Salva.

Thanks Salva for your prompt response.

Yes, please. I appreciate your guidance on how to disable those functionalities.
I’ll disable all of them and then enable them one by one at a time and monitor the performance accordingly.

Thank you in advance.
Ibrahim

• This reply was modified 3 years, 8 months ago by ibrahimoo.

Hi @ibrahimoo

I’ve not tested it but I believe this should remove these calculations in WC orders:

remove_action( 'woocommerce_after_order_object_save', array( \Atum\Inc\Hooks::get_instance(), 'update_atum_sales_calc_props_after_saving' ), PHP_INT_MAX );

Best Regards,
Salva.

Hi @salvamb,

Many thanks for your support.

Actually I like ATUM and therefore I’m considering this as a TEMPORARY solution.
So, do you think it’s worth a re-evaluation the performance and make some improvements?

All the best.
Ibrahim

Hi @ibrahimoo

We are continuously improving ATUM and also its performance. If we find a better way to improve this in any way, we’ll do it, for sure.
But, please note that calculating values like these need to run complex queries to the database can take time to complete depending on the number of orders and number of products you have in your database. So, probably, who is consuming so many resources is your MySQL database when running the queries.
We could delay this (as we are already doing for other calculations) to be executed in the background on a separated thread, but I doubt this is going to reduce the resources needed to run these queries and the CPU consumption that you are checking here.
Anyway, in my opinion, that some process has a peek of resources temporarily from time to time, it isn’t a big deal (unless it affects to the overall site performance while running). There would be a problem if this consumption is permanent (that isn’t the case with ATUM).

Best Regards,
Salva.

I’m confident that ATUM team is up to this challenge and will keep improving this plugin.
Great job!

Thank you! ??