cfquery with maxrows = faster processing ?

[BKBK]

Yes, there is an increase in speed, as returning 10 rows is less work than
returning 50, but that may not be the whole story. Most of a query's work is
done in getting the result set from the database in the first place. I presume
that Coldfusion would have been designed in such a way that it caches the full
result set in a buffer, even though it only returns a maxrows of 10. If so,
then the overall increase in speed from using maxrows will not be significant.
In any case, I even wonder whether it's any use thinking of speed gains for row
numbers as small as 50.

[PaulH *TMM*]

BKBK wrote:

> done in getting the result set from the database in the first place. I presume
> that Coldfusion would have been designed in such a way that it caches the full
> result set in a buffer, even though it only returns a maxrows of 10. If so,

depends on the db & db driver. in something like sql server when the
resultset reaches the maxrows value processing stops on the server.
something like access probably gets the whole resultset & that is truncated.