Need help with Query Optimization Tool

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:

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.

Sounds like fun. Good luck.