Working with and manipulating large datasets

[Hydrowizard]

What experience has everyone had working with and manipulating large datasets in coldfusion? I imagine this is more an sql server question in my specific case but I would be very interested if someone could enlighten me on what I need to look out for any potential pitfalls and best practises working with coldfusion and what I should learn. Thanks in advance for any pointers

[Guest]

I guess it depends on the purpose of the application in question. We are running a scientific data mining application in ColdFusion for the last 5-6 years without any major glitches that will force us to rethink about ColdFusion. The dataset in this application are quite large with 30-40 different tables and some of tables have more than 100 million records.

However our queries are usually highly optimized with intelligent use of index and hints (we use Oracle).