# Need help with Query Optimization Tool

**URL:** <https://forum.inductiveautomation.com/t/need-help-with-query-optimization-tool/116959>\
**Category:** Ignition\
**Tags:** namedqueries, scripting, ignition81, perspective\
**Created:** [September 1, 2026, 12:40pm UTC](https://forum.inductiveautomation.com/t/need-help-with-query-optimization-tool/116959 "2026-09-01T12:40:40Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![lane.duncan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lane.duncan/32/83700_2.png) [@lane.duncan](https://forum.inductiveautomation.com/u/lane.duncan)\
**Post date:** [September 2, 2026, 5:42am UTC](https://forum.inductiveautomation.com/t/need-help-with-query-optimization-tool/116959/3 "2026-09-02T05:42:06Z")

</div>

The official recommendation is to remove Ignition from the picture and test queries directly with the database management software, as slow queries are normally a database issue, not an Ignition issue:

> **[Slow Queries | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.3/platform/sql-in-ignition/basic-sql-troubleshooting/slow-queries)**
>
> Slow running queries can be a big problem. Not only can data take a long time to display on the screen, but it can end up slowing down the whole client or session. This page covers checks and adjustments you can make when your project has a slow...

That being said, a “Query Execution Analysis” test tool would be an interesting project.

Looking at named queries only, I suppose you could (1) get a list of queries by listing the files in the directory, then (2) you could inspect the files and try to determine the parameters required, then (3) a script could be generated to test and time all the queries.

This sounds like a lot of work that will produce mediocre results at best.

Maybe this is a good task for an AI agent. You could start with logging all the queries and feeding the log to the agent, and have it write the results to a db table, which can the be displayed in Ignition.

> [@SQL Query Monitoring](https://forum.inductiveautomation.com/t/sql-query-monitoring/58646):
>
> I know there are query monitoring tools from different database providers but I was wondering if there was a way to log/print all the queries requested by Ignition to any database connection. May be something within system.db ?

Sounds like fun. Good luck.

---

_[View the full topic](https://forum.inductiveautomation.com/t/need-help-with-query-optimization-tool/116959)._