> Ok I have found that when i return alot of returns to a page,
> 5000+ it adds
> quite a bit of time to the processing on the CF side with displaying the
> information as opposed to it being database bottleneck.
My guess is that it's less of a CF issue and more of a bandwidth issue.
Like, how large is the resulting html page when you have to display 5000+
rows of data? How much cf code and html code is in each iteration of the
5000+ loop? You are talking about a pretty large file that needs to go from
the CF server to your client machine.
To answer your question, I would definitely chunk it into 500 record pages
with next/prev.
- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
