Hello [@Gabriel lEVIN](/u/gabriel)

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:

```sql
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](/u/giftedhands4real)**, 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](https://sma.gehandsitsolutions.com/)

### 📞 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](/u/giftedhands4real)

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?

```sql
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

No solution yet, I did all the indexes.
10141 transfers.
9532 Puchases.

The last one solve the problem, txh Mian Saleem
I didnt see the add ons u made on the sql code.

Hello,

I am glad that you noticed and the indexes improved the query time.

Thank you for updating

Hi now i have this problem
I dont know if this is the resultt of this chanches.
can u help me ?
Only happend when i try to change state to Completed
In transfers.

Hello,

The product doesn't have the quantity you transferring in the from warehouse. Please check the quantity in the from warehouse.

Thank you

The item is sent but, the error happen when the other side try to confirm the transfer, status sent to completed.
If i do transfer with completed status , direct, the error is not presented.