db-ojb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Anthony <charles.anth...@hpdsoftware.com>
Subject RE: only grab 10 records
Date Tue, 11 Nov 2003 14:07:42 GMT
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:czerwonka@arcticpenguin.ca]
> 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:czerwonka@arcticpenguin.ca]
> > > 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:czerwonka@arcticpenguin.ca]
> > > > > 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: ojb-user-unsubscribe@db.apache.org
> > > > > For additional commands, e-mail: ojb-user-help@db.apache.org
> > > >
> > > > ___________________________________________________________
> > > > HPD Software Ltd. - Helping Business Finance Business
> > > > Email terms and conditions: www.hpdsoftware.com/disclaimer
> > >
> > > 
> ---------------------------------------------------------------------
> > >
> > > > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > > > For additional commands, e-mail: ojb-user-help@db.apache.org
> > >
> > > --
> > > Andy Czerwonka
> > > (403) 547-8892
> > >
> > >
> > > 
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
> > ___________________________________________________________
> > HPD Software Ltd. - Helping Business Finance Business
> > Email terms and conditions: www.hpdsoftware.com/disclaimer
> >
> >
> >
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> -- 
> Andy Czerwonka
> (403) 547-8892
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 


___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer 



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


Mime
View raw message