Why are you using CF for data transfer of this sort? Most databases come with software for exactly this kind of stuff. What DB are you using?
> -----Original Message----- > From: Jeff Green [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 7:17 PM > To: CF-Talk > Subject: Querying 1 million records > > > Im going to have to deal with some large amounts of data, queries that > select 1 million records. > > Is this something CF should be able to handle? (CF5 on win2000 with 512 > RAM) > > One thing I want to do is query one DB and insert recs to another DB, > approx. 1 million recs. > > Thanks for any advice, > Jeff > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
