db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein.Grov...@Sun.COM (Øystein Grøvlen)
Subject Re: derby performance and 'order by'
Date Wed, 21 Sep 2005 13:54:04 GMT
>>>>> "SAD" == Suavi Ali Demir <demir4@yahoo.com> writes:

    SAD> Another little detail about optimization is that
    SAD> Statement.setMaxRows() kind of functions on the JDBC side may
    SAD> not be sufficient since it is called after SQL statement is
    SAD> prepared and returned as an object (after query plan is
    SAD> built). Therefore, it may be necessary to have language
    SAD> syntax to indicate the intention to fetch first 1000 rows
    SAD> only, so that when the query is prepared, this intention can
    SAD> be taken into account.

It would be much better if this could be changed at execute-time for
an already prepared statement.  That is, the same prepared statement
could be used regardless of how many rows one is going to fetch.


View raw message