If they're read-only and what you're looking for is
performance, I'd put the tables into memory (e.g.
Oracle has option to suck entire tables into
memory--the last I used this there was a penalty if
you updated them though) and use stateless session
beans to get the data with query methods. Let the
RDBMS cache the data and keep the stateless session
beans dumb...otherwise you never know when the
Container will decide to passify something (stateful
session or entity). Also this way you won't have to
worry ahead of time about what types of reports,
de-normalization, etc.
--- Shawn McKisson <[EMAIL PROTECTED]> wrote:
> I will track this thread as well... This guy is
> looking for fast reporting it
> appears.
>
> --shawn
>
> -------- Original Message --------
> From: Mihir Mehta <[EMAIL PROTECTED]>
> Subject: Modelling Read Only Database Tables
> To: [EMAIL PROTECTED]
>
> Hi EJB Gurus,
>
> What is the best way to represent read only
> database tables in EJB.
>
> I have following options :
>
> 1. CMP Entity Beans
> 2. BMP Singleton Entity Bean per table
> 3. Stateless Session Bean
> 4. RMI Server
>
> To me option 1 seems overkill.
> Option 2 seems ok, but I do not know how to make
> portable singleton
> entity beans.
> For option 3 I would like to get some idea on how
> to make a
> stateless session bean available to various
> clients efficiently.
> I guess with option 4 I would have to worry about
> the server crash,
> restart, and synchronization.
>
> I would appreciate if you would share some well
> established
> patterns, techniques and recommendations.
>
> Thanks,
> Mihir
>
>
===========================================================================
> 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".
>
>
===========================================================================
> 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".
>
>
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
===========================================================================
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".
