Thanks John. John D Allen President/CEO. Leveridge Systems INC -----Original Message----- From: Assaf Arkin <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, January 31, 2000 2:59 PM Subject: Re: Database Optimization With Entity Beans >dan benanav wrote: >> >> Assaf Arkin wrote: >> >> > What you are suggesting, if I understand it correctly, is to use proxies >> > into entity beans that only load them when they are needed. That would >> > be equivalent to just hold a reference to the primary key, passing it >> > around, and then loading the entity when you really need it. >> > >> >> But I'm not suggesting to hold only the reference. The detail object contains more >> information about the entity bean then just the primary key. That way when you are >> iterating through the Enumeration you won't have to call a method on an entity bean >> since the information you need is already in the detail object. > >I was just trying to simplify your proposal to better understand the SQL >load. > >I like it. > >arkin > >> >> > >> > If you are doing your own SQL selects and bypassing the finders, I would >> > like to make a suggestions: bypass the BMP model altogether, use JDBC >> > with fetch buffers, cursors and all the other performance tricks. This >> > approach certainly scales to one millions results. >> > >> >> The entity bean would contain update methods and other methods that modify the >> database. > >-- >---------------------------------------------------------------------- >Assaf Arkin www.exoffice.com >CTO, Exoffice Technologies, Inc. www.exolab.org > >=========================================================================== >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".
