CFQUERY and maxrows attribute

[dougk]

ok, maybe I'm on some bad crack today, but I recall that the maxrows attribute
of cfquery works AFTER the resultset is returned to CF from the DB. Is this
the case for all RDBMs? I'm noticing that this is not the case with CFMX and
Oracle. Maybe this behaviour changed? I'm now seeing teh maxrows attribute
being utilised in the DB itself. So, if I pass SQL returning 1000 rows to
Oracle and maxrows=200, oracle returns only 200, 201 actually, rows to CF. was
this change documented somewhere?

[dougk]

bump

[Tom Jordahl]

Not changed but documented in the description of maxrows.
"maximum number of rows to return".

If we aren't limiting the data back from the RDBMs, then where is the
savings in network or memory?

--
Tom Jordahl
Macromedia Server Development