Why does Retool runs all queries inside a model, regardless if they have a disable flag?

[David_Mazvovsky]

Hi Team,

I have several modules included in my main app. I've noticed that all BigQuery queries that I have created inside the modules have been run when the main app is loaded, even if they have a disabled condition.

Is there a workaround? It slows my app down and costs me BigQuery money.

Thank you.

[ScottR]

What is the disabled condition? Are the queries set to run only when triggered manually?

[David_Mazvovsky]

I've tested with just putting "true" in the condition, for testing

[ScottR]

Which one is selected?

[David_Mazvovsky]

The first one "run automatically". I also need this setting because my SQL has filters.

[ScottR]

Are you chaining the queries to run in sequence?
Also, check out this post by @bradlymathews

Option to Disable all queries in a Module from Parent app

I have wanted this feature for a while but this post crystalized my ask: Why does Retool runs all queries inside a model, regardless if they have a disable flag? I often put a module in a modal or otherwise hidden until the user needs to interact with it. If the user never interacts with the module, then any queries it runs affect performance. Especially if it is tied to a table's selected row or other case that causes it to constantly requery. There may be other use cases where even if the mod…

[joeBumbaca]

Hey @David_Mazvovsky! The queries definitely shouldn't run if set to disabled with true. So let me know if you are still seeing that. We do have an internal ticket tracking the request from the post that @ScottR linked, so we can update when we have any new information. In the interim, the workaround with the module input flag is likely your best bet.