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




Reply via email to