Suresh Kumar Govindaraj wrote:
> I want to write a query to get a large result set of customers, which I
> will use for reporting. Can it be done using stateless session beans or
> does the specs say I should use entity beans, for all data access?
Don't use entity beans for large result sets. They are too heavyweight.
Well, I should say: don't use entity beans for large result sets if the
number of concurrent users you expect to be using your system will be
high.
In general, for reporting-type problems, I'm in favor of just letting
the database do what the database does best and hitting it with either
(a) a stateless session bean if for some reason you absolutely have to
use EJB technology or (b) hitting it with a regular JDBC query and
extracting only what you want. Reporting applications are generally not
very reusable (in our experience, anyhow) and often objectifying them
doesn't buy you very much.
Just MO.
Cheers,
Laird
===========================================================================
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".
