0056549: after incremental refresh process, the first scan is slow

Description

With big volume of data (40K products), after incremental refresh process is executed, the first scan is slow:
https://drive.google.com/file/d/1HtPo4wiPDht52Dt3tueyMlRRlQwKminp/view?usp=sharing [^]

This issue is caused because a search is triggered by the MultiUpc module, but the database is busy "Loading cache for Model." Until the database completes the cache loading process, the MultiUpc query is not executed.

The query is executed in this line:
https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/blob/master/web/org.openbravo.retail.multiupc/js/extendUPCSearch.js?ref_type=heads#L71 [^]

Steps To Reproduce

. in environment with 40K products, install multiupc module
. execute incremental refresh
. scan a product

Proposed Solution

. if the database is executing the cache loading process, then execute the product search as remote

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0170558) hgbot (developer) 2024-10-18 09:02	Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/26 [^]

(0170567) hgbot (developer) 2024-10-18 13:04	Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/26 [^]

(0170568) hgbot (developer) 2024-10-18 13:04	Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc [^] Changeset: 6d8d373831477aeeebbfa23297e2dfafd3990c7f Author: Sabarinath <s.palanisamy@external.orisha.com> Date: 18-10-2024 14:15:16 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/6d8d373831477aeeebbfa23297e2dfafd3990c7f [^] Fixed ISSUE-56549:Remote product search triggered when cache loading was in process. --- M web/org.openbravo.retail.multiupc/js/extendUPCSearch.js ---