Hi All,
I am developing an application that can scan a barcode and then search in the SQL view. The SQL server is on an on-premise server and a gateway connector is used to connect to it. This gateway connector is connected to the production server. On the production server, it takes 15 to 20 seconds to return a value from the SQL.
To display the data, the search query is filled by the barcode and the following formula is used:
Filter(VW_SCANNER_APP, 'Barcode No_' = SearchQuery || 'Item No_' = SearchQuery)
Then I show the items with thisitem.barcode & thisitem.title etc.
I have no idea where to look to optimize the performance. But it should be less then 5 seconds to be used in production. On the acceptance server, it took 5 to 6 seconds. Both configurations are the same.
Additional information:
- The SQL view is named VW_SCANNER_APP and contains around 55.000 to 60.000 items.
- In SSMS on the server the items are returned within a second.
- The search query is populated by the barcode value.
Thank you in advance!

Report
All responses (
Answers (