# Find out where Named Querys are called in Ignition

**URL:** <https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081>\
**Category:** Ignition\
**Tags:** perspective, vision\
**Created:** [December 13, 2023, 1:35pm UTC](https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081 "2023-12-13T13:35:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Spachinger](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@Thomas\_Spachinger](https://forum.inductiveautomation.com/u/Thomas_Spachinger)\
**Post date:** [December 13, 2023, 1:35pm UTC](https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081/1 "2023-12-13T13:35:47Z")

</div>

Hello,

on our SQL Server Database activity monitor i have detected a Named Query thats executed about 100k times each miniute. I know, that he query is inherited by our global project to most of the projects on the gateway.

Is there a way to find out, where Named queries are executed in perspective/vision?

Greetings

---

<div class="post-metadata">

**Author:** ![calimero100582](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/calimero100582/32/18630_2.png) [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\
**Post date:** [December 13, 2023, 2:27pm UTC](https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081/2 "2023-12-13T14:27:22Z")

</div>

easiest way I have, to do this kind of thing, is to open the projects folder (under data) in VS Code, or using Agent Ransack (paid tool), and search for the query name.

---

<div class="post-metadata">

**Author:** ![Thomas\_Spachinger](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@Thomas\_Spachinger](https://forum.inductiveautomation.com/u/Thomas_Spachinger)\
**Post date:** [December 13, 2023, 2:42pm UTC](https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081/3 "2023-12-13T14:42:11Z")

</div>

Ok, thanks!

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [December 13, 2023, 2:44pm UTC](https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081/4 "2023-12-13T14:44:35Z")

</div>

> [@Thomas\_Spachinger](#):
>
> about 100k times each miniute

Doubt it. I think you misread or mis-reported this. That's ~2 _per millisecond_.

---

<div class="post-metadata">

**Author:** ![Thomas\_Spachinger](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@Thomas\_Spachinger](https://forum.inductiveautomation.com/u/Thomas_Spachinger)\
**Post date:** [December 13, 2023, 2:51pm UTC](https://forum.inductiveautomation.com/t/find-out-where-named-querys-are-called-in-ignition/83081/5 "2023-12-13T14:51:10Z")

</div>

sadly not. Already found the script. some1 coded an execution of the query in a loop like:  
while 1\<2:  
system.db.run...

... cant upload the image