I ran into the same problem implementing a search capability. I gave up on using entity beans and wrote a session bean that used SQL/JDBC. It was taking about 2 min. to display about 50 results (create 50 entity beans). After I switched to a session bean using JDBC, I can search and display 50 records in under one second! There was just too much overhead in creating the entity beans. I am resigned to using entity beans only when I need to update data managed by the bean or fetch and work with a single bean. For search and multi-fetch results (more than say 5), I use session beans with immutable data objects that mirror the get methods of the Entity bean and can easily be passed back to the caller in an array.
For example, I had a bean called Reservation. So, to search for reservations, I tried a finder method but ended up w/ a session bean called SearchReservations. It has a search method to which I pass a criteria object. Search returns an array of immutable reservations (ReservationImmutableImpl). It was more code to write, but it is faster and requires less network traffic, and overhead from the bean container, etc.
It is too bad because using the entity bean finder methods was easy and it was a clean and simple looking implementation.
Good luck and please let me know what you end up doing to resolve your problem. I'm curious.
Regards,
-Bill.
At 04:29 PM 8/4/00 -0600, you wrote:
Does anybody know of a way to speed up performance for Jonas?
I'm retrieving 52 rows from a database using a find method. The
performance is unbearable. I'm using Container Managed Persistence
on all the entity beans. I've tried making sure that all the methods
are in transactions, but it doesn't seem to matter.
Any help would be appreciated.
--
Duggan Dieterly Phone: (970) 898-7906
Software Design Engr. Fax: (970) 898-6376
Hewlett-Packard Co.
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
Bill Bunting, CTO
IncentiveMeetings.com, LLC
email: [EMAIL PROTECTED]
Web: http://www.incentiveMeetings.com
