Performance Optimising Your Wappler App - THE DEFINITIVE THREAD

[Antony]

I've just discovered a method that enables me to push a lot of work I was doing on the client side back to the database...

See the article below for details!

Using Database Views with Case Statements to Vastly Improve App Performance

Well I’ve been able to answer my own question, and the possibility is amazing! Basically you can define a “view” in MySQL with as many aggregates and additional columns as you choose, and that View acts like another table… so the view appears as another table in the Database Query action and can be selected from there. The other thing I’ve discovered is the use of the CASE statement within a select which means I don’t really need to use a stored function. So here is a simple view example. We…