Skip to main content
S
ssailer
Inspiring
November 13, 2008
Question

ColdFusion / SQL Server database - number of records?

  • November 13, 2008
  • 5 replies
  • 1439 views
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!
This topic has been closed for replies.

5 replies

tclaremont
tclaremont
Inspiring
November 17, 2008
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.
S
ssailerAuthor
Inspiring
November 14, 2008
Thanks, everybody!
A
Anonymous
November 14, 2008
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
D
Dan_Bracuk
Inspiring
November 14, 2008
SQL server probably can. Bringing all 5 million into Cold Fusion might cause problems though.
S
ssailerAuthor
Inspiring
November 14, 2008
So, CF can't handle 5 million records? what can? Thanks!
K
Kronin555
Participating Frequently
November 14, 2008
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.
N
Newsgroup_User
Inspiring
November 14, 2008
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices