Problem with saving time

[yomri001]

Hi guys,

Please I hope someone can help me with this case:

I created an inventory management app, where the concerned tables are "Rolls", "Order" and "Order_Details". Rolls contains the list of the products, and Order details contain the products linked to an order.

My issue is with the saving time when I create an order containing 10 to 30 products, the app takes up to 5 min to save the changes! 

for each new row added to Order_Details table, there is a bot that run to change the product status from Available to Sold.

Here is a video showing the process and how much it takes to save the changes.

https://drive.google.com/file/d/1dLxGwS11KiEcLI_Z_hR56YCdRd8S1Tj4/view?usp=sharing 

Also here is a screenshot of the app performance: 

I would love to have your assistance in solving this issue.

Note: The concerned tables don't have any virtual columns, just REFs.

@Suvrutt_Gurjar @Steve @WillowMobileSys @Koichi_Tsuji