Hello @Gabriel lEVIN

If your Transfers and Product Quantity Adjustments take too long to load and MySQL reaches 100% CPU usage, here are some possible solutions:

1. Reduce the number of rows per page

Go to System Settings and lower the Rows per page value. If it's currently set to 100, try reducing it to 50 or 25.

2. Ensure proper indexing

Make sure that product_id and transfer_id in the sma_transfer_items table are indexed. This will improve query performance.

3. Optimize database indexing

Run the following queries to add indexes to key columns, improving query speed:

ALTER TABLE `sma_transfer_items`
	ADD INDEX `transfer_id` (`transfer_id`);

ALTER TABLE `sma_sales`
	ADD INDEX `warehouse_id` (`warehouse_id`);

ALTER TABLE `sma_sale_items`
	ADD INDEX `option_id` (`option_id`);

ALTER TABLE `sma_quotes`
	ADD INDEX `warehouse_id` (`warehouse_id`);

ALTER TABLE `sma_quote_items`
	ADD INDEX `option_id` (`option_id`);

ALTER TABLE `sma_purchases`
	ADD INDEX `warehouse_id` (`warehouse_id`);

About Me

My name is @Enyinnaya Gift, and I am an Independent Software Developer with in-depth knowledge of the SMA system. I have successfully implemented numerous customizations for happy clients worldwide.

🔹 Check out a demo of my latest customization:

Click HERE - Highlights

📞 Reach me for real-time discussions on your customization requests via:

📌 Skype: enyinnayag
📌 WeChat: genyinnaya
📌 Email: [email protected]
📌 WhatsApp: +2348068355192

Thank you for helping @Enyinnaya Gift

Hi, thx for the fast response, no improvements, just take 10 minutos or no response at all to show resultos, in transfer details and Quantity adjusts.

Hello,

Did you add indexes?

ALTER TABLE `sma_transfer_items`
	ADD INDEX `transfer_id` (`transfer_id`);
ALTER TABLE `sma_transfer_items`
	ADD INDEX `product_id` (`product_id`);
ALTER TABLE `sma_transfer_items`
	ADD INDEX `warehouse_id` (`warehouse_id`);

ALTER TABLE `sma_purchases`
	ADD INDEX `warehouse_id` (`warehouse_id`);

ALTER TABLE `sma_purchase_items`
	ADD INDEX `transfer_id` (`transfer_id`);
ALTER TABLE `sma_purchase_items`
	ADD INDEX `product_id` (`product_id`);
ALTER TABLE `sma_purchase_items`
	ADD INDEX `warehouse_id` (`warehouse_id`);

How many transfers and purchases do you have? What are the specs of your server? Please increase the memory_limit to minimum 256M in your php config file.

Thank you