Then I have a problem. Is there a way to say 'select next record order by column' in OJB? My issue is I have a queue table with 200,000 records in it, and I'm doing a getIterator() which works fine on a few (<10000) records, but anything more than that it's very slow. I need to select less records, process them, select more, process them, select.....
Any recommendation on a strategy? On November 11, 2003 6:41 am, Charles Anthony wrote: > Hi, > > It is not possible to do this in a cross platform way, so No, currently > this is not possible in OJB. > > For an explanation of the reasons why, see > http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+per >f ormance+issues > > Cheers, > > Charles. > > > -----Original Message----- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2003 13:35 > > To: 'OJB Users List' > > Subject: only grab 10 records > > > > > > Does anyone know if its possible to do something like this in OJB: > > > > select * from table where criteria but only return me a > > maximum of 10 records. > > > > Is this possible? > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > ___________________________________________________________ > HPD Software Ltd. - Helping Business Finance Business > Email terms and conditions: www.hpdsoftware.com/disclaimer > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Andy Czerwonka (403) 547-8892 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
