What application do you need that is going to return that many
records? You aren't planning on giving the user a single list of all
records, are you? It may be better if you break up the list somehow.
You can start by using 'top 1 * from mytable' to return the top row
from your result set. Does the page still lock up, or does that work as
expected? How about returning top 100? Or top 1000? If you are intent
on not breaking up the list, you may look into the blockfactor attribute to
the CFQUERY tag, which controls how the rows are processed by
ColdFusion. For example, a blockfactor of 10, will process the rows 10 at
a time before going back to [memory, database?] to get the next 10.
At 08:59 AM 05/01/2001 -0400, you wrote:
>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
