db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Ondruška" <peter.ondru...@gmail.com>
Subject Re: getting first k rows from a query that satisfy some additional condition
Date Mon, 27 Oct 2008 21:59:09 GMT
Please, post the query you are running.There are queries where setMaxRows
will not be faster, for example if you do GROUP BY or ORDER BY.

On Mon, Oct 27, 2008 at 22:51, Amir Michail <amichail@gmail.com> wrote:

> On Mon, Oct 27, 2008 at 5:45 PM, Daniel Noll <daniel@nuix.com> wrote:
> > Amir Michail wrote:
> >>
> >> Hi,
> >>
> >> What is a good way for efficiently getting the first k rows from a
> >> query that also satisfy some additional condition to be determined
> >> using Java code?
> >
> > setMaxRows(int) is the standard way of doing this in JDBC, it only falls
> > over if you later want to retrieve rows k..(2k-1).
> >
> > Daniel
> >
>
> It's slow with setMaxRows.
>
> Amir
>
> >
> > --
> > Daniel Noll                            Forensic and eDiscovery Software
> > Senior Developer                              The world's most advanced
> > Nuix                                                email data analysis
> > http://nuix.com/                                and eDiscovery software
> >
>
>
>
> --
> http://chatbotgame.com
> http://numbrosia.com
> http://twitter.com/amichail
>

Mime
View raw message