Ask a Question related to Coldfusion Database Access, Design and Development.
-
Dan Bracuk #1
Re: cfquery with maxrows supposed to be faster?
The query speed will not be affected. The page will load more quickly though, if you are displaying only 10 rows of data rather than 50.
How long is it taking your query to run anyway?
Dan Bracuk Guest
-
cfquery with maxrows = faster processing ?
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... -
Using Maxrows with Nested Output
This seems so simple but how does MAXROWS work with nested queries that are grouped? If you apply it at the top level it limits the number of... -
CFQUERY and maxrows attribute
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. ... -
CFGRID ? maxRows
I agree with ArtNirvana. If you have maxRows then is reasonable to have page navigation and also you can think about record locator based on sort... -
DuplicateMovieClip goes faster and faster
hi! I'm trying to program a game in which oranges drop down. These oranges are created by a duplicateMovieClip. A new orange is created everytime... -
Adam Cameron #2 Re: cfquery with maxrows supposed to be faster?
> The query speed will not be affected.
Well... *yeah*, it will be. It difference is likely to be trivial if the
DB has only to produce 50 rows, of which CF only "listens" to ten, but
there is overhead there.
If one wants to restrict the size of a recordset, one should always used
DB-system-specific row limitations (TOP, LIMIT, ROWNUM filters), rather
than CF's "maxrows". All maxrows does is tell CF to stop listening to the
returned data after that many rows, it does not do anything to advise the
DB system to curtail its processing.
--
Adam
Adam Cameron Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
