Depends what you want it to do. I'd suggest indexing your tables so you
have optimum performance and then limit the number of records returned by
the DB. I can't imagine you want to display all 40,000 recs do you?
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 01 May 2001 13:59
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
