They can't see that much on one screen anyway. So break it up and only give
them 500 at a time. You can use startrow and maxrows for that.
Or you can spit it out in a .csv file that will pop up in excel or
openoffice. I did this all the time with CF8 and it is even easier now with
cf9 because
well, you can try using CFFLUSH in the end of your cfoutput
query=myQuery block.
--
From: David Mineer min...@gmail.com
Sent: Thursday, October 22, 2009 12:37 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: How to display LARGE amounts of
If you're putting the data on 10 different tabs, then only call or render
the data for the first one and use DHTML / Ajax to load the each other tab
only when a user clicks on it. Basically, it's slow right now simply
because the size of the HTML document being returned to the user is
cache your query so u dont have to access the database each time
Sincerely,
Chuka I.W. Anene
Chief Software Eng./CEO
Quorium Solutions
www.quorium.org
07029609185,07032696113
From: Rick Colman rcol...@cox.net
To: cf-talk cf-talk@houseoffusion.com
Sent: Thu,
Your problem is probably render time, which makes sense if you have a ton of
data coming out in a table layout.
What you can do is remove as many of the tables as possible, especially for
any layout stuff, headers, footers and the like. If you wrap the entire
contents of the page in a table,
I need to query, retrieve and display a large amount of data; i.e. 4100
rows by 50 columns of numerics, to the browser screen. It is really
slow, and after some testing, the bottleneck seems to be on the page
that displays the data. The query is OK and connection is ok. But, the
user has to
6 matches
Mail list logo