Hi,
I have been working on a TV scheduling application based on EJB for several
months now and I 'm now looking at performance tuning of the server.
The system uses stateless session beans that call stored procedures in an
Oracle database. I also maintain a disk based cache of schedule objects that
are heavily used and change infrequently due to the very slow speed of
retrieval from the database (legacy system).
When a client requests a set of schedules I call a fairly quick stored
procedure to get a list of schedules that have been modified in the
database, which returns zero rows most of the time but is still a bit slow.
Ideally I would like to have this procedure running at the same time that I
am loading objects from the disk based cache but the EJB spec prohibits me
from spawning threads from within session beans.
Does anyone have any suggestions on how I can achieve the same results
without resorting to vendor-specific features ?
Thanks,
Andy Grove
Technical Architect
British Sky Broadcasting Ltd.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".