I need to write all 50,000 recs to a csv file
The workaround I have opted for was to use SQL DTS.
Nick.
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 24 July 2001 17:44
To: '[EMAIL PROTECTED]'
Cc: Nick Betts
Subject: RE: 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?
The best way around this is to reconsider why you could possibly need to
retrieve 50,000 records. You're not going to display them all at once,
and
you're not even going to want people to be able to page through that
many
records.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
