----- Original Message -----
Sent: Wednesday, March 24, 2004 10:50
AM
Subject: [cf-dev] RE: [ cf-dev ] Cached
query
Whats the DB? The db could need
optimising...
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
