db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject Re: getting first k rows from a query that satisfy some additional condition
Date Mon, 27 Oct 2008 21:51:33 GMT
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