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:51 AM, Aristedes Maniatis <[EMAIL PROTECTED]> wrote: > > 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'? > Certainly using an ORM will be slower than native SQL calls, but for > most developers this is not nearly as important as having code which > is quick to write, reuse and refactor. And easy to read. But I guess > that is why you are here. > > As for fetching large numbers of records, take a look at Cayenne's > paging [1] functionality. For customised query/update/insert code, > perhaps SQL templates [2] will be useful to you. > > What sort of load do you intend putting on your ORM/database that > requires more than these optimisations? > > > Ari > > > > [1] http://cayenne.apache.org/doc/paginated-queries.html > [2] http://cayenne.apache.org/doc/sqltemplate-query.html > > --------------------------> > ish > http://www.ish.com.au > Level 1, 30 Wilson Street Newtown 2042 Australia > phone +61 2 9550 5001 fax +61 2 9550 4001 > GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A > > >
