ColdFusion / SQL Server database - number of records?

[ssailer]

Can ColdFusion and a SQL Server database handle around 5 million records in the database, or is there another database that would work better than SQL Server? Any ideas? Thanks!

[Newsgroup_User]

ssailer wrote:
> Can ColdFusion and a SQL Server database handle around 5 million records in
> the database, or is there another database that would work better than SQL
> Server? Any ideas? Thanks!

if your servers' h/w are up to spec & your db/app are designed properly, sure.

[Dan_Bracuk]

SQL server probably can. Bringing all 5 million into Cold Fusion might cause problems though.

[ssailer]

So, CF can't handle 5 million records? what can? Thanks!

[Kronin555]

ssailer, what Dan meant was that if you try to read all 5 million records into CF at one time, you're definitely going to run into some memory management issues.

I doubt you're going to be doing something like this though:
<cfquery datasource="mydatasource" name="superlargequery">
select * from massivetable
</cfquery>
where massivetable has 5 million rows. I don't know what you'd do with that result set that wouldn't be better served by limiting the results or doing aggregate functions in the query.

[ssailer]

Actually, only one record would be returned at a time. Criteria would be entered for one field and it would need to be an exact match.

[scottcook]

non-issue, no-brainer on CF side. Presuming your database server is up to the task. 5 million records isn't really all that much

[ssailer]

Thanks, everybody!

[tclaremont]

When you get into that size table, the difference between good performance and bad performance is the developer that creates/maintains the database, and the coder that writes the CF code.

Just about any hack can set up a table with a couple hundred rows, and an ugly CF page to retrieve whatever. Not much concern about memory, or response time, or thread management, etc. So, the happy coder thinks he did a good job. When that database grows to millions of rows and suddenly everything is slow as molasses, that is when poor coders point to CF... or the database... and claim that the software can't handle the job.

Summary? If your installation of CF and SQL can't handle it, I suggest the problem is between the keyboard and the chair.