On Mar 17, 2004, at 1:37, Reinier Mostert wrote:
> 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.
Perhaps you can use prefetch from unit to part in your query?
http://www.objectstyle.org/cayenne/userguide/perform/prefetching.html
- Tore.
This archive was generated by hypermail 2.0.0 : Wed Mar 17 2004 - 02:08:41 EST