Webmaster Forum / ColdFusion / Getting Started / July 2007

The app server generally doesn't care so long as it supports the DB driver. If
the database is designed properly, the DBMS will be doing most of the "grunt"
work.

Any enterprise level app server can process a large database, so go with your
strengths, and SQL server will do you just fine.

Yes is is fine to go with CF. I have worked with both .NET and CF website.
There is basically no difference in the performance.

The performance and speed of the application basically depends on DB design
and business logic. If we had DB with poor design like no keys, indexes etc and
poor business logic like unnecessary code, loops then this will anyway affect
the performance of the application whether that is CF or .NET and whether you
have 100000 or 1000000 records in DB.

Thanks

CF and sql server work fine, I have CF coneected to 8GB databases, without issue.

80k to 100k, as enterprise DBs go, isn't really all that big. We have one (of
several) intranet-related DBs that has well over a million records.

And as SafariTECH says, it's your DB system that should be doing all the heavy
lifting, so your app server is less of a factor in determining performance.

We use both CF and .NET here, and I've never noticed any difference in
reliability or speed between the two when it comes to DB interaction.
ColdFusion would be a great choice for your site.