That is too much to get the browser to render at a time, narrow the display
results, if not the recordset.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 7:59 AM
To: CF-Talk
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
