Re: Big list'o questions.....

2008-03-02 Thread Andrus Adamchik
Hi Frits, On Mar 3, 2008, at 1:37 AM, Frits Jalvingh wrote: The later. This is not configurable in Cayenne. I strongly suspect that PreparedStatement caching is never a bottleneck in the case of update (and in any event, if we issue a set of different UPDATE queries for each entity, each variati

Re: Big list'o questions.....

2008-03-02 Thread Malcolm Edgar
We use Cayenne SQL Queries (named queries) for doing reports and complex joins, and have it return light weight RowMap objects. This is a great facility, you get all the benefit of SQL access, but don't have to write all the supporting JDBC code. regards Malcolm Edgar On Mon, Mar 3, 2008 at 10:5

Re: Big list'o questions.....

2008-03-02 Thread Aristedes Maniatis
On 03/03/2008, at 10:37 AM, Frits Jalvingh wrote: This means I would not use Cayenne for any kind of work that handles large amounts of objects; something that is not advisable anyway for the current generation of ORM's. I think it 'depends'. That is, what do you call 'large amounts'? Ce

Re: Big list'o questions.....

2008-03-02 Thread Frits Jalvingh
Hi Andrus, Thanks for your swift reply!!! > PreparedStatement caching can be configured outside Cayenne at the > DataSource level. Cayenne by itself doesn't do PreparedStatement > caching and doesn't care about it. Check. > > > 2. When Cayenne executes updates does it update the entire recor

Re: Big list'o questions.....

2008-03-02 Thread Andrus Adamchik
On Mar 2, 2008, at 9:11 PM, Andrus Adamchik wrote: 3. The documentation states that when you call rollbackChanges() a transaction the DataContext state is restored to the state it had before. Does it do this by using "copies" of the objects it has read or is the database re-queried? Rollback

Re: Big list'o questions.....

2008-03-02 Thread Andrus Adamchik
On Mar 2, 2008, at 7:25 PM, Frits Jalvingh wrote: 1. When Cayenne accesses the database, are PreparedStatements used (and cached) within a single DataContext? That is: if code causes 100x the same SQL to be generated and executed (select xxx from yyy where id=?) is this prepare once, cac

Big list'o questions.....

2008-03-02 Thread Frits Jalvingh
Hello there, I am evaluating Cayenne for use in a new project. I have read the documentation and experimented a bit but I'm left with a few questions. I hope I can get some answers here ;-) 1. When Cayenne accesses the database, are PreparedStatements used (and cached) within a single DataContext