What's faster, running the query in Google sh...

(Grant Stead) #1

What’s faster, running the query in Google sheets, or a virtual column?

(Grant Stead) #2


(Praveen Seshadri (AppSheet)) #3

It depends on the expression.

It should be Google Sheets, but we do some pretty good optimizations in our backend so there will be some cases where a virtual column actually runs faster.

(Grant Stead) #4

@praveen I’m looking at a basic filter/select…

(Levent KULAÇOĞLU) #5

@Grant_Stead with complex queries, we generally prefer to use the gSheet rather than the VC, as complex query expressions in a VC are quite expensive and results in long sync times.

(Stephen Mattison) #6

Was just wondering this, TY!