Hi,

we have finally moved to Hibernate, but performance is pretty poor.

We tried:
- no fk pointing to non-existing records

We have quite a large object graph with 100+ Classes, no inheritance but quite a few relations.

All numbers timed on server start:
Using standard fetch and occasional fetch=join: 4 times slower than ojb
Using fetch=join throughout: 7 times slower than ojb
Using proxies: even worse performance

It seems far too many sqls are generated and sent to the DB (Postgres).

Any advice on which avenues to explore appreciated.

Thanks,

Stefan