What is it that you are trying to do with the 50,000 records? Surely you
won't be displaying that to a browser? If so, your putting an awful load on
CF (looping over 50,000 records). Also, your browser would most likely be
the entity that is timing out, not CF. CF will keep churning away until the
task is completed (which would explain the eating up of resources).
A query that returns 50,000 records should be a piece of cake for a robust
database like SQL Server or Oracle (assuming proper design and indexing
etc). However, its not practical to attempt to format and display such a
large volume of data using a browser and Cold Fusion (or any other language
for that matter).
Brian
----- Original Message -----
From: "Nick Betts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 11:10 AM
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
>
>
<snip>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
