Perspective query VS scripting


I have a question, maybe a little basic but…I need to create a interface in Perspective with data from a single place.

It’s better to create a lot of small queries to make basic math like SUM or COUNT values from it or have a single big dataset and put scripting on him to ‘analyze him’. (Script will be on value change), dataset it will be max. 450 rows and 3 columns.




Personally, I script it. That said, where I run the script from depends on the application. If it’s something that display the same data across all sessions and not as interactive, I’d do all of it in a gateway script. If it’s something where ‘individual analysis’ come into play, then I’d script it in a session, keeping the dataset on a tag.