Hello ejb-fans, I am facing a design issue. I appreciate your suggestion/advices. Here's what I have in the database subscriber table, publisher table, mapping table: primary keys are a combination of subscriber ID and publisherID and has one attribute, status. I have developed 2 entity beans to represent subscriber and publisher. I am debating wheither or not to implement the mapping table as another enitity bean. The mapping table will be constantly accessed by subscriber and publisher. Subscribers can subscribe to publishers, publisher can add/delete/change the status of subscribes. From time to time, we need to know how many subscribers/status for a publisher. Currently I have a session bean for interacting with the publisher entity bean and I'm writting my own query/update methods to get the information from the mapping table. The reasons for not developing the mapping table as ejb are 1. to limit the number of entity beans to avoid overhead on the ejb server. 2. The status in mapping table are not likely to change once it's set. 3. When I do a search on the mapping table, i'm also looking for subscriber name, email. I think it's better to get all the info through a db query rather than use finder method to instantiate all subscribers and get their name and email. But again, I feel like I have to query into the database all the time.. (whenever user access the web page). I wonder if an entity bean (CMB) for the mapping table will provide a better performance instead ?? If yes, what's the advantage of it ?? Moreover, how does ejb finder methods differ from my own-query methods in terms of the performanace ? PS. the database connection is retrieved from the connection pool. Thanks for your time. Cheers! Sydney Chen Macroplay.com Inc. =========================================================================== 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".
