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
This archive was generated by hypermail 2.0.0 : Sun Mar 02 2008 - 18:51:54 EST