Performance issue in a production environment

Support
1

I am facing a major performance discrepancy between Dev and Prod. A search on a local table (219k records) using the Primary Key (Postal Code) is instantaneous in Dev but takes between 20 and 40s in Prod. The tables and data volume are identical. It seems like the index is not being used or there is a major I/O bottleneck on the production instance.

Thank you for your help!

Jean

2

Update: it seems to be a refresh UI problem. I tried to insert refresh() in my function but that didn’t make any improvement.
const form = getCurrentForm();
const measurementsPage = form.getPage(“Measurements”);
measurementsPage.refresh();

See the following gif run on the dev environment: as soon as I click outside the “Code postal” field, the fields “Ville” and “Région” are immediately updated with a sql query run on the server side.

dev

But now on the prod environment, I must mouse-over the “Ville” field in order to have it updated. And concerning the “Région” environment (which use a lookup query), one must click on another tab and then come back in order to have it updated.

prod

Do you have any idea what is the problem? Thanks for your help.

3

Hi Jean,

I have sent you a direct email, so we can take a closer look at this for you.

Kind regards,

Jo