Cayenne supports batch updates (if your JDBC driver does). This will
provide similar performance, by rolling the load into a single
transaction... though its definitely not as fast.
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.
On 12/14/05, Lothar Krenzien <lkrenzie..eb.de> wrote:
> Hi there,
>
> I would like to know is it possible to do a kind of bulk update in cayenne. For example :
>
> update tblXXX
> set col1 = blablabla
> where ....
>
>
> I think it should give a performance benefit to use the 'native' update command in contrast to do a lot of updates in a loop from java. Is that true ? I'm using cayenne 1.2.M4
>
> Thanks for your answers.
> Lothar
> __________________________________________________________________________
> Erweitern Sie FreeMail zu einem noch leistungsstarkeren E-Mail-Postfach!
> Mehr Infos unter http://freemail.web.de/home/landingpad/?mc=021131
>
>
This archive was generated by hypermail 2.0.0 : Wed Dec 14 2005 - 12:24:55 EST