Find out where Named Querys are called in Ignition

Ignition
,
1

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

2

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.

1 Like
3

Ok, thanks!

4

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

5

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

2 Likes