I believe that most containers only query PKs in in the finder method. The actual bean isn't loaded until you access it. Assuming this is true, 1million PKs shouldn't be a serious resource hit and you can handle the situation however your project requires in the code (i.e. throw error request a more specific search).
Kevin E. Gaasch Panhandle Plains Student Loan Center Software Craftsman Work: 806.324.4100 x4215 Cell: 806.674.1523 >>> Daniel OConnor <[EMAIL PROTECTED]> 11/26/02 05:59AM >>> The MVCSoft Persistence Manager supports this feature by allowing you to specify a "wrapper method" for the finder with two additional parameters specifying the exact set of records you want. There are a variety of ways you can configure the engine to accomplish this behind the scenes, e.g. "limit/offset" syntax, or scrollable cursors, or simple result set iteration. This wrapper method can be abstract, because the MVCSoft deployment tools provide an implementation. Alternatively, you can implement the method with code that manually iterates a result collection to get the records you want. This will maintain portability of functionality (although deploying the application on an EJB container with a different persistence mechanism might in practice be a "performance bug"). The MVCSoft PM is available for JBoss, Jonas, WebLogic, WebSphere, Orion, OC4J, and JRun. -Daniel O'Connor On 25 Nov 2002 at 19:24, Milind Kulkarni wrote: > Hi All, > > We have more than 1 million records in Customer Database. We have > requirement that the output of a search query should be limited to 1000 > records only. Can anybody quickly let me know how do you achieve this > using EJB-QL. > > Thanks in Advance ! > Regards, > Milind > > =========================================================================== > 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". =========================================================================== 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".
