How to monitor Cached Queries in Lucee?

Behnam · December 14, 2024, 5:44pm

Hi,
How can i Monitor the Cached Queries in Lucee? I use queries like below:

<cfquery name="testQ" datasource="test" maxrows="3" cachedWithin="#createTimeSpan(0,2,0,0)#">
        SELECT		id,name 
        FROM		table1
    </cfquery>

Roberto_Marzialetti · December 14, 2024, 8:46pm

What do you mean by “monitor”?

Since Lucee version 6 you have Query Listeners that help you understand how many times a query is executed and other stuffes.

github.com

lucee/lucee-docs/blob/master/docs/recipes/query-listener.md

<!--
{
  "title": "Query Listeners",
  "id": "query-listeners",
  "since": "6.0",
  "description": "Learn how to define query listeners in Lucee. This guide demonstrates how to set up global query listeners in the Application.cfc file to listen to or manipulate every query executed. Examples include defining listeners directly in Application.cfc and using a component as a query listener.",
  "keywords": [
    "query",
    "listener",
    "Lucee",
    "Application.cfc",
    "component"
  ]
}
-->

# Query Listeners

Since Lucee 6.0, you can define a listener in the Application.cfc to listen to or manipulate every query executed.

This file has been truncated. show original

Behnam · December 14, 2024, 9:54pm

Thanks a lot for reply.
By adobe coldfusion administrator panel:

you can easily find out the executed queries and sort them by times or execute time.
After that, you can cache the ones you prefer to.
Then you can monitor the cached queries and tune up-to a good situation.

Im looking for something like that in lucee or any 3rd party extensions.

Roberto_Marzialetti · December 15, 2024, 3:17pm

As far as I know, there is nothing out there that can do what you ask for.

I never used it, but check this:

Alternatively, I think you can create something quite easily with Query Listeners.