Well, that really won't work, because the table i'm selecting from has the following properties.
- It's a queue. - Each record has a status (not_processed and error) - I need to select only (not_processed) - If, while processing, it get a business error, i set the record to error and move to the next. If no error, I delete after processing. So, it's a challenge setting the endIndex() because I never know how many 'error' records are sitting at the top of the queue. On November 11, 2003 7:30 am, Andy Czerwonka wrote: > the setStartAtIndex() and setEndAtIndex() seems to work... so I could get > the first record, get the unique id, and then ask for the next, say 20 > records. I could do that each time in the loop. Thoughts? I do need to do > two selects each time though.... any way to get it down to 1? > > On November 11, 2003 6:49 am, Charles Anthony wrote: > > Which Database ? > > > > > -----Original Message----- > > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > > Sent: 11 November 2003 13:55 > > > To: OJB Users List > > > Subject: Re: only grab 10 records > > > > > > > > > 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/mat > > > ch=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] > > > > ___________________________________________________________ > > 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]
