Formula Queries

I think that is not really a question which is directly answerable.  If you had just one "pain causing" formula query and you had 100 users on a report that relied on that formula query and they were hammering at those reports all day then yeah it's going to slow down the app.  

Or if you had 100 different formula queries on 100 different reports and 100 different users were using their own report that would be the same amount of load.  

ie, a dormant Formula Query does not hurt performance, it only causes load when Quickbase finds that it needs to recalculate the result to display a report or a record.

I don't know if you have one app or many apps but you probably have a sense of your app performance just by working with the app and seeing how responsive it is.  If the app is starting to slow down and you have a high enough plan level there are some tools available from QuickBase performance experts which can rank what are called long requests.  If I recall correctly, a long request is one which takes more than five seconds.  

My inclination would be to do what you gotta do to create an app which is user-friendly.  If you do start to run into performance issues you dig into specifically which reports or dashboards are causing that performance issue and only take a step back and rethink the approach if you are forced to for performance reasons.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------