Hey @maillme!
To start, we do have this doc on performance best practices: https://docs.retool.com/docs/app-performance-best-practices
And to answer your specific questions,
- Can I load a query when a tabbed container moves for example, or, when a modal box opens.... rather than 'loading 'all the time'. I did experiment with 'only when triggered' but then i wasn't able to trigger in a way tat was user friendly.
- > Yes! Let me know if something like this would be helpful: http://community.retool.com/t/run-query-on-container-tab-select-option/3986/9
- Should lI load one big query and populate all drop-downs on page vs smaller simple ones
- > If the net data coming into your app is the same, I think smaller queries might perform better since you're not stuck waiting for the big query to finish. Not entirely sure, but that's what I'd suspect!
- Should I create a view in my postgres db and then just pull everything from there?
- > Hmmm. How much data are we talking?
