I think the answers are yes and no. ColdFusion should have no problems querying against 1 million records. If you want to query from one DB and insert into another DB, I have to wonder if ColdFusion is the best tool for the job. If you are on SQL Server, look into using DTS. I am sure that Oracle / Sybase have a similar functionality.
At 06:16 PM 7/12/2002 -0700, you wrote: >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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
