Appsheet Performance

[Gokul1]

Which option is better for performance?  add 10 more columns to my sqldatabase, with a few if statements in each column on appsheet  or load up a single column on appsheet with dozens of if statements?

[WillowMobileSys · Accepted solution]

This depends on how you need to structure the dozens of IF() 's.  If it is a usage where you only need to find the first match and then return, then you could use an IFS() conditional expression and it would be more performant.  Otherwise, if you need to go through ALL of the dozens of IF()'s each time, the two asked options would be equally performant.