Actually that will work provided you original query is correct....
In SQL if you said
SELECT *
FROM QUEUE
WHERE X = 'Not Processed'
Then you limit that to the first 100 rows you should be fine... Because the
returning result set will start numbered @ rownum 1 and move to 100 -
remember result sets are just sets of rows ordered by what you selected. (An
assumption but I bet a safe one). If you On the other hand left out the
where clause provided that you had a clustered index on the table end it has
'Not Processed" values on the top, the above would also be true as you will
BY default get the un processed ones first due to the index and how the
result set will get created.
Joe
On Tuesday 11 November 2003 1:00 pm, Andy Czerwonka wrote:
> Again, I don't think this will work, because I want 100 records, but I want
> the first 100 where column x = y.
>
> On November 11, 2003 7:07 am, Charles Anthony wrote:
> > In which case, I believe you can use the pseudo column "rownum". See
> > previous message
> > http://article.gmane.org/gmane.comp.jakarta.ojb.user/4038/match=rownum
> > for an example of adding the appropriate SQL to a query...
> >
> > Note, this will tie your application to Oracle.
> >
> > Cheers,
> >
> > Charles.
> >
> > > -----Original Message-----
> > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED]
> > > Sent: 11 November 2003 14:11
> > > To: OJB Users List
> > > Subject: Re: only grab 10 records
> > >
> > >
> > > Oracle 9i
> > >
> > > 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]
> >
> > ___________________________________________________________
> > 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]
--
Dealing with failure is easy: Work hard to improve.
Success is also easy to handle: You've solved the wrong
problem. Work hard to improve.
- Alan Perlis
-----------------------------------------------------
Joseph Campbell | EMAIL: [EMAIL PROTECTED]
Staff Consultant | URL: www.inventa.com
Inventa Technologies | PH: (856)914-5200
| PGER: (888)454-0876
-----------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
