Avoiding cache/invalidating

From: Reinier Mostert (rendie..labo.co.za)
Date: Tue Mar 16 2004 - 19:37:21 EST

  • Next message: Tore Halset: "Re: Avoiding cache/invalidating"

    Hi all,

    I have two related tables in a database with 90% of the data going into
    the database using straight SQL queries. Call the tables "unit" and
    "part". Each unit can have many parts.

    Now I do a SelectQuery on unit, and then step through the "parts" for
    every "unit" in the result. If a new part is added, or an old part is
    removed using SQL I don't see this change when I perform the query
    again. This is because the parts are in the cache.

    How do I invalidate the parts so they get reloaded? Do I need to run
    ctxt.invalidateObject on every (cached) part before doing the "unit"
    query again? Should I do a query on "part" that returns (and refreshes)
    the correct subset of parts for the specific "units"?

    Is there an easier way to ensure I get refreshed parts?

    thanks
    reinier

    This archive was generated by hypermail 2.0.0 : Tue Mar 16 2004 - 19:46:05 EST