There is a thread with a lot of performance related issues on that I started and I know @patrick contributed to… but I’ve just spent 10 minutes in various searches and can’t seem to find it! 
We apply a lot of ‘No Auto Load’ to our data fetching and only load upon a request by the user, on a click, certain action or combined action. Pages load super fast with huge amounts of data ready to go. Caching for data that really doesn’t change a lot, and cookies and sessions for persistence. On the DB side we prepare as much we can in very efficient queries with tables that are not overly saturated with a load of non essential bloat. A few days spent tweaking your database configuration and learning about efficiency/optimisation is essential. Often overlooked by a lot of users…
My wife, for instance, loves cooking. She has hundreds of ingredients. She does not throw them all in the same pot for a meal. She takes what she needs and adds to the recipe. If I want to add ketchup I’ll do it at the table! 
5 Likes
Hahaha, or pineapple!
Thanks guys, all good advice. Except… I like pineapple on my pizza!
2 Likes
A man of pizza culture I see.
2 Likes
My sentiment exactly Jon!
Nooooooo! Hahahaha.
As someone capable of baking something like this in my domestic oven I find your comment absurdly offensive 
4 Likes
Another ananasophobic added to my black book.
3 Likes
Ooh, that just needs a bit of pineapple and some ketchup and I think you’ll have a winner 
If I knew how to say it and knew what it meant (quickly Googles!) then I might disagree with you 
Some very harsh comments on here today 
2 Likes
Dare I be a real bore and bring us back to the topic at hand? (no, not 
)…
Some questions come to mind:
-
What is the best way to see how much memory the browser is using to run our app?
-
How do we know that number is near the limit?
-
How much of a difference will it make if lots of other tabs are open and other apps running on the computer being used? Can we easily see what are the best things to close to give our app more room to breathe?
-
Are some browsers more memory/resource efficient for a typical large Wappler SaaS app and therefore better to recommend our clients to use?
Don’t underestimate yourself! Real bore? More like a pizza party pooper!
I believe it would be even better if you start a new topic as those questions deserve a topic and a huge discussion.
3 Likes
DONE
1 Like
I’m hearing quite often here problems that developers are having that seem to indicate that they don’t have querying database experience. Which is HUGELY important to optimizing data dependent apps.
Today’s databases have ENORMOUS power & speed to process complicated views, tables, comparisons, sorts, joins using conditionals far faster & reliable that handing these app requirements off to a million different User device environments.
Having started in PHP and MySQL years ago I am surprised that people are trying to make a user’s browser process traditionally server actions ON-THE-FLY when the user’s data bandwidth or IP connection and model of phone device and version of browser and on-board cache is assigned to the App if it is mobile, etc.
When even node apps can connect to a php/mysql stack for querying data more queries should be written to allow today’s version of mysql or nosql varieties to on-the-server set up the tables & views.
Typically, on an adequate host the database serves up EVERYTHING in milliseconds, including 3 or 4 or 5 table joins with conditional filters.
On your database server, as you know, you can define common queries that sit already cached without requiring your user’s devices to process anything but to filter for displays.
How many are using this Wappler-advised Goodie?
Then open the State Management category. In this tutorial we will show you how to cache the data in the local storage, but you can also store it in a session if you like. So - we select local storage manager:
https://docs.wappler.io/t/caching-api-data/3671
For SQL queries (depending on host database installation some of these tips will be invalid – not work or deliver promised improvement.
https://www.winwire.com/25-tips-to-improve-sql-query-performance/
Sometimes i’ve handed off complex queries to a Query Expert, such as listed on the Freelance-for-hire sites. A good query expert can come up with alternative views which I save as Custom Queries. I save myself hours & hours of noodling around trying to build a particular query where I am completely ignorant about the “magic” ways a Query professional can tackle my problem and get a ridiculously fast result.
7 Likes
We do the same. Tools for jobs. If you’re going to do it properly do it properly in the right way with the right tool and if that requires external intervention by an expert all the better for your application.
Great reply @NewMedia (wish I could like it twice).
1 Like