Well a couple of things that you may want to do. 1. Make sure and index your table properly, especially on any fields that may be searched upon and you may want to consider doing a clustered index.
2. You may want to limit your output to a certain number of rows 3. Get some more memory Other than that, you should be ok.... Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 7:01 PM Subject: Re: Querying 1 million records > CF isn't the issue, it would be more a database/machine issue, you will need > a robust database to handle your queries... look at your memory a bit you > may want to have it bumped up! > > Paul Giesenhagen > QuillDesign > ----- Original Message ----- > From: "Jeff Green" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, July 12, 2002 8:16 PM > 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 > > > > > ______________________________________________________________________ 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
