Part of the problem is that browsers just are not made to handle 40,000+
records, especially if the code is not really tight. CF can generate an
awful lot of white space if you're not careful. Depending on how much info
is in each record, the page you're trying to return is could very well be in
excess of 10-20 megabytes in size. If your computer/browser has enough RAM
and CPU horsepower to handle it, it must calculate it all out and render it.
This takes time, if it will do it at all. You need to find some way to pare
down what you're trying to return to the browser. Must you return it all to
the browser? What would you even do with 40k records on your screen? How
would you deal with that? Why not look for specific records? Explain more
what you're trying to accomplish.
Dave
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 8:59 AM
Subject: Really large recordsets (40,015 records) won't return
I have a query that returns 40,015 records when run in Oracle SQL*Plus.
When I try to run this query in a .cfm page, it just hangs - no timeout
messages, no nothing, just sits there and hangs and occasionally locks up
the browser. I tried setting the timeout (<FORM ACTION
="pc4DisplayResults.cfm?RequestTimeout=2000" METHOD="post" NAME="ThisForm"
ID="ThisForm">) which doesn't seem to help. Is there some setting I can
change on CF Server? Something I can put in my code? Does anyone have any
suggestions how to handle this?
Gina Shillitani
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
