db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paulo Jesus" <paulsch...@gmail.com>
Subject Re: limit # rows
Date Thu, 03 May 2007 17:41:47 GMT
I´m new here and i don´t  know this channels very well.
If i need to do something like that, where can i do it?
I was requested to implement a new interface over derby so i will need it.

PJ


2007/5/3, Kathey Marsden <kmarsdenderby@sbcglobal.net>:
> 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