On Dec 14, 2005, at 8:24 PM, Cris Daniluk wrote:
> I'd try letting Cayenne do its thing, and if you find its too slow,
> you can use a SQLTemplate to run queries like this. Just be careful,
> because the objects in memory may get out of sync with the database,
> since this is essentially bypassing Cayenne.
Exactly - if you have some objects in memory, using Cayenne to update
both DB and objects *in sync* is the most consistent thing to do, and
probably also the fastest, as we've optimized this code over the years.
If you are sure that you don't have the objects in question in-
memory, and just running a bulk DB update, then it is up to you - you
can either use SQLTemplate or UpdateBatchQuery.
Andrus
This archive was generated by hypermail 2.0.0 : Thu Dec 15 2005 - 04:09:11 EST