db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: limit # rows
Date Thu, 03 May 2007 17:20:27 GMT
Paulo Jesus wrote:
>     stmt.setMaxRows(1);
> at the application i can get one row, but i would need to make some
> effect on server.
> I have tested with and without setMaxRows() function but the results i
>   got make understand that limit is make by the driver after the
> query execution.
> This can make a big difference on execution performance, but i didn't
> find references on it.
>
> Is this implemented?  How can i improve this type of query?  This is a
> simple query, without any 'order by'.
>
I think you would have to file this as an enhancement request.  It could 
potentially be implemented using the same strategy as DERBY-506, 
setQueryTimeout.

Kathey





Mime
View raw message