Andy
Keep a cache and have the db server send changes :-).
Tony
----
"Grove, Andy" wrote:
>
> 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".
--
Tony Holderith | Interactive Business Solutions
[EMAIL PROTECTED] | NetCentric Solutions
http://www.interactivebusiness.com | Business Objects
Phone: 310.414.6760, 805.893.4503 | FAX: 310.414.6759
===========================================================================
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".
