If each record is even a decent size, then even if CF was able to handle a query that size, the machine would run out of memory and start swapping like crazy, and then you are thinking about looping over cfquery 1,000,000 times? Egads...don't do it, for the sake of your server :)
If you have a database that can handle 1,000,000 records, it's probably a decent dbms no? Use your database to handle manipulation of large datasets, not CF. -- jon Friday, July 12, 2002, 9:16:31 PM, you wrote: JG> Im going to have to deal with some large amounts of data, queries that JG> select 1 million records. JG> Is this something CF should be able to handle? (CF5 on win2000 with 512 JG> RAM) JG> One thing I want to do is query one DB and insert recs to another DB, JG> approx. 1 million recs. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
