Yes, queries cost WU whenever you hit the DB.
1 Like
Yes, thank you @pieter.vanrensburg for confirming the concern of WUs. If you are concerned that your WU costs are excessive for reporting function, consider checking out Data Jedi, a paid plugin, that makes a Hybrid Data Structure easy to implement that can save 95% on data retrieval. Perfect for reports that need to be seen often and for not needing to create a poorer UX just to save some WUs on data retrieval.
Interesting plugin @boston85719. However, I’ve already migrated most of my data into SQL. Finalizing a decision around a professional reporting tool. Cost will be much higher but the enhanced capabilities and FIXED cost makes sense to us.
I think this is the wrong place for your question. But I’ve had to set lists of things to their index in multiple situations in the past. Bulk AND recursive backend workflows were a pain, and stupidly costly for what would otherwise be a lightning fast script in javascript. Someone found a solution and it works a million times better than anything else. Check it out in this thread, and if you have any questions about it, ask there. Hope it helps you!
It works on the front end, so if you dont NEED that, you can always set yourself up a little admin page with the data set you need there in an RG, and run it with a button/workflow.
1 Like