Hello,
I am facing some performance issues with Castor. The web app I am working on
includes a search engine.
When I do a search, almost all the database is put on memory.
As no lazy mecanism is implemented for 1 to 1 relationships, Castor create a lot
of objects that are not used.
So I have already made some optimizations :
1/
I have created a specific mapping for the search engine. It works better but
takes sometimes 20 secondes for 1 query.
2/
I use CALL SQL in order to bypass the sql generation. It works fine as long as I
don't have 1 to many relationships.
As soon as a data object include a collection, it does not work anymore.
Does Castor support this kind of direct call?
3/
The database is Oracle 9i. I am used to limit the number of rows returned by a
sql request (with the keyword rownum).
Is there a way to limit the number of rows returned by the database with Castor?
4/
Do you have some ideas to increase the performance? (Castor specific only).
Best regards,
Bruno CHEVALIER
Project Manager
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
