Syncing taking too long

[Uribe]

Hello experts!

Sometimes my app takes too long to sync. 9 seconds feels like eternity when waiting for an app.

Here is a screenshot of the performance details:

It took 8 seconds to read {"RowsRead":"14877","ColumnsRead":"12"} . It's a "Read-Only" table. There are no virtual columns or security filters on that table. There is one slice with the expression: "[Cambios] > 0". The app's data is stored in Google Sheets.

I have enabled server caching, sync on start, delayed sync and automatic updates. Disabled delta sync and quick sync.

Is it a normal time for that table?

[Denny774]

Hey man,

why do you need to read 15K rows at once? 😆

PS. I always have QuickSync Enabled

[Uribe]

Hey Denny, the app is for consulting / checking inventory. 
I need a line on the table for every barcode. So, there are 14,000+ barcodes

[Denny774]

Hey,

well, wouldn't it be better to search for a barcode and thus deal with only one line at a time?

[Uribe]

What do you mean? It’s a whole table, can’t decide which lines to read and which don’t

[Denny774]

You could use a slice of data and filter it

[Uribe]

I need the whole data to be available to be read, in case a user needs to consult something from the 14,000+ items in the store

[RedVox]

Do you have virtual columns?  I've found that eliminating virtual columns has the greatest impact on getting my apps to speed up.

[Uribe]

Hi. 
I don’t have virtual columns on the app, except for a ref column in another table.

[Marc_Dillon]

Seems a bit slow. Is it a deployed app on a paid plan?

[Uribe]

Yeah, is deployed on the Core plan

[AleksiAlkio]

So.. you have the virtual REF_ROWS() column in your table, right? You mentioned you have 14k+ barcodes. Do you have them in this table? Are they barcode images?

[Uribe]

No, the ref_rows() is in another table.

The barcodes are numbers.

[AleksiAlkio]

Is the Ref column then in this "Datos Maestros" table?

[Uribe]

No, is not. Is in another table

[AleksiAlkio]

Do you have any sheetformula in this or in another sheet?