RE: [ cf-dev ] Cached query

[Robertson-Ravo, Neil (RX)]

Whats the DB? The db could need optimising...     From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: 24 March 2004 07:16 To: CF - List Subject: [ cf-dev ] Cached query 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 This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com