db-ojb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andy Czerwonka <czerwo...@arcticpenguin.ca>
Subject Re: only grab 10 records
Date Tue, 11 Nov 2003 14:10:45 GMT
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


Mime
View raw message