# Perspective query VS scripting

**URL:** <https://forum.inductiveautomation.com/t/perspective-query-vs-scripting/57250>\
**Category:** Ignition\
**Created:** [March 16, 2022, 12:00pm UTC](https://forum.inductiveautomation.com/t/perspective-query-vs-scripting/57250 "2022-03-16T12:00:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul.M](https://avatars.discourse-cdn.com/v4/letter/p/c0e974/32.png) [@Paul.M](https://forum.inductiveautomation.com/u/Paul.M)\
**Post date:** [March 16, 2022, 12:00pm UTC](https://forum.inductiveautomation.com/t/perspective-query-vs-scripting/57250/1 "2022-03-16T12:00:24Z")

</div>

Hello,

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.

![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/6/16d973bfa250a92b759e1513a7ba1cd48daa4440.png)

Thanks,

Paul

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 16, 2022, 12:13pm UTC](https://forum.inductiveautomation.com/t/perspective-query-vs-scripting/57250/2 "2022-03-16T12:13:08Z")

</div>

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.