Are you actually planning on returning a million rows to CF and trying to display or manipulate it somehow or just indicating that the tables will be large and you are querying against a million rows? If the former, good luck. Moving a million rows out of one DB and into another using Cold Fusion will take en eternity as you will have to do the inserts one row at a time. Better to bulk out and bulk in the data or something along those lines.
Justin p.s. We use CF all the time with tables that has 10+ million rows, the db is the issue, not CF. > -----Original Message----- > From: Jeff Green [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 9: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
