Hello everyone,
I'm currently using Barcode module for scanning products. However, when I clicked on an order (which only had a few products), the module loaded all the products inside my database back to the client through get_all_product_by_barcode method.
The problem is, this method is extremely slow. It loaded 64000 products in almost 50 seconds every time I clicked on an order. My workflow is slowed down so much because of it.
Does anyone have solutions for this?
Thank you.
You can inherit this function in a custom module and instead of searching via orm, you can do it direct search using sql queries, which will reduce the time