Use an SP to select the records or if you have to use CFQuery use
blockfactor in the CFQuery tag. Also look at what types of cursors you are
using to select the recordsets from within SQL (i.e. keyset or static) as
these impact on performance
------------------------------------------------------------------
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: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: 24 July 2001 17:10
To: CF-Talk
Subject: Selecting a large amount of records
I have a SQL server 2000 db holding around 50,000 recs. I need to
select the full 50,000, however CF server eats resources then times out.
Any way round this??
Nick.
-----Original Message-----
From: Ang�l Stewart [mailto:[EMAIL PROTECTED]]
Sent: 24 July 2001 16:59
To: CF-Talk
Subject: RE: (Admin) Footer
************************************************************************
*************
* Remember to check the CF FAQ
http://www.thenetprofits.co.uk/coldfusion/faq *
* that answers several Common Queries
*
************************************************************************
*************
If you want people to notice it, you need to put it as a small header
that people see above each message, rather than as just
a footer.
4 lines should be enough.
-Gel
-----Original Message-----
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
It's being worked on. The real question was if anyone noticed the bottom
message area. Besides the FAQ and other list info, I was thinking of
replacing the banner ad with community stuff like important sites and
such.
As we have no paid banners there we might as well make it useful in
other
ways.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
