[ cf-dev ] Cached query

[Allan Cliff - CFUG Spain]

I have a control panel for a website.   When the user logs on a query runs to do a lot of checks on the database to produce a report. This query has become slower and slower due to the amount of data now in the database.   I decided to cache the query which is fine until the cache time is ended and the next person to login has to have this wait of a couple of minutes while this query happens.   I want to try and schedule this query to take this wait away. If the cache time is say 2 hours how could i do this to stop anyone having this wait.   If I do a schedule every 2 hours and 1 minute it would work fine until the server restarts and then that would throw everything out.   Your 2 pennies worth please.   Allan