Hi,

I am trying to cache some of the SQL queries on some of the pages to make sure the app runs quicker. I was wondering, does the query itself get cached or is the table in the database cached. If i run a timer in the morning which runs all the tables, does that mean the results are cached? Or would I have to go to a webpage for the query to be cached?


Regards,

Archit

Archit, the query results will be cached.

If your timer uses exactly the same query as a web screen (note that the query would need to be refactored into a server action), then the cache will serve both timer and screen.