Optimize formulas (FUNCTION: LOOKUP) to make an app faster

[daniel_sanchez]

Hi, I created an App to Manage the entrances to mi warehouse, I also with the same app manage the outs. It works in the following way:
We paste the information about each skid the material in a table called " Skid Load Summary" the information contains:
Load Number (the number is not repeated, each skid has a unique load number), trailer number, carrier to pick up, and date to delivery.

 When the trailer arrives at my warehouse, the user scans each pallet, and in the APP shows it to the carrier to pick up (FedEx, UPS, Etc)..

The scans of the entries saved on another table called "escaneo de Skid", for the app shows the information that previously load in table "Skid load Summary" I used the function lookup:

In many processes, to my app, I used the function lookup, and then as more and more data is added it gets slower and slower to do a sync.

the sync times exceed the one minute: 

The question Is: is there a better way to optimize or some other function that does not affect performance so much? 

[Marc_Dillon]

It's not the use of the LOOKUP expression itself, it's your use of Virtual Columns.

Stop using so many virtual columns. Save data in real columns if you don't need it to be constantly and dynamically updated.

Also use references and dereferences where you can. Like if you need multiple values from the same record, don't use LOOKUP twice, use it once to get the key value in a Ref column, and dereference the multiple needed values through that.

https://help.appsheet.com/en/articles/961426-references-between-tables

https://help.appsheet.com/en/articles/1090811-dereference-expressions

There are quite a few large threads about optimization strategies on this forum. Search for things like "virtual columns", "performance", "reduce sync", etc. Like this:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Improving-performance-by-getting-rid-of-unneces...

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-to-avoid-expensive-virtual-column-expressio...

[daniel_sanchez]

Thank you Marc_Dilon 

"Stop using so many virtual columns. Save data in real columns if you don't need it to be constantly and dynamically updated."

Unfortunately yes I need constant dynamics updates because the material crosses the border between Mexico and USA, so is very difficult to predict times to arrive, many times a load comes with a carrier appointed but if the cross delays, the sender changes the carrier to pick up for another carrier (HotShot, Expedite) so we need the information update. when creating the app I tried using real columns but the information don't update. 

Daily we receive approximately 10 Trailers and an average of 200 load numbers (Skids). I have merchandises that have a future date to delivery, and others who pending instructions for delivery, and the sender change constantly this instruction.

i will review all the links you give me. I appreciate your help