cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@dff.st>
Subject Re: [ESQL] Improvement....
Date Sat, 25 Jan 2003 18:07:38 GMT
> WHAT IS WRONG?
> 
> In example A all is OK.
> 
> In example B we are not using the power of the Database Manager.
> 
> WHY?
> 
> The LIMIT clause was designed to tell the database engine:
> 
> "Let find just X rows", then the database engine when it got the X rows
> stop searching and return the X rows. It improves the response time, since
> does not to continue searching!
> 
> Now think in a 10 million row table and YOU KNOW you need only 5 rows!

whether 10 million rows or not - the current sollution will only ask for 
6 - one additional row. Is that the time penalty you are talking about?
--
Torsten


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message