db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Heilman <mheil...@usatech.com>
Subject Need help keeping cache & DB in sync
Date Wed, 21 May 2003 14:34:14 GMT
Here is the problem as I understand it:

1. Torque caches the results of a query.  
2. Then a user/dba updates a table directly from sqlplus.  This update
changes the results of the query in step 1.
3. Torque does not see the updated data and has the original values cached.

How can I force Torque to update the cache whenever a database change is
made outside of Torque?  Is there any way to keep the two in sync?  I do not
want to turn off the cache.

View raw message