<[EMAIL PROTECTED]> wrote:
>
> when an update or delete is made to the database all
> queries that are possibly affected are requeried and
> cached again rather than being removed, once every 20
> updates/deletes a clean up routine is invoked.
I see many problems here:
* It fails if your update or delete from a different
database connection or a different process such
that the update or delete is not detected by your
wrapper.
* Inserts also effect the results of subsequent
queries.
* Updates, deletes, and inserts that are the result
of triggers will be difficult for your wrapper to
detect.
* The code that determines what cached queries are
effected by an update or delete is likely to be
a persistent source of bugs that are very
difficult to reproduce.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
