My app did not laod successfully even though I only add 1 virtual column in my table

0 2 74
2 REPLIES 2

Error clearly indicate your problem. Timeout is the issue.
Your table could be large and your virtual expression is expensive. Should be due to both reasons.
Better to apply security filter to reduce the number of records to send to your device.

Indeed, using a MAX(SELECT()) on a virtual column is telling the app to search every row to obtain a list, and then search within every row of that list for the max value , depending on the filtering conditions (where there could be more expressions) that could mean going through all your table 2-3 times for EACH row on EVERY sync.

Top Labels in this Space