Has anyone implemented a lot of formula queries (100+) in their app?
I have only implemented about 20, and I love them, but am afraid of performance issues. I am wondering if anyone has used a lot - if so how many, are they on large tables, and are you having any performance issues?
I could make 1000 to help me if I wasn't worried about performance, but I don't have any concept of what is 'a lot' of formula queries.
Is 50 a lot? is 500 not very many? Are they expecting users to have 1000 formula queries or 20?
------------------------------
Mike Tamoush
------------------------------
Question
Formula Queries
+24I 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
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.