Got ya, Thanks for that! It did occur to me after I posted that this likely isn't anything just running on background periodically waiting for my users since its just a JS code query.
I guess what I realize I am trying to 'learn' the best way to do is how best to have my query stored in retool such that the user doesn't have to wait for tons of API calls when they open the app. I know I could park data in the Retool Database and that might be faster than API calls, what other options exist (if any)? Perhaps none without the end user opening the app and triggering queries/code? Looks like perhaps variables do this? I'll look around but appreciate any suggestions. Thanks, I'm still learning lots of the retool options.
edit: I gather this might be my answer: " Variables are reset each time your app is loaded. We are currently rolling out support for persisting values across browser sessions. If this isn't yet available for you, you must write the values to a database or localStorage."
another edit: Ok, I think I'm finding the likely answer which I assume is discussed above and in this post (unless there are new options that have emerged):