How much IPC delta is there between Pentium D and Haswell? (integers only)

[Chicken76]

Are we talking 50%, 100%, 150%, what?

Let me explain why I'm asking this.
We have a web server running on an old Pentium D and installed recently a complicated web application to be used internally. It's sloooooowww....
A single access/click puts a core to 100% for several seconds (php&mysql) so you can imagine how frustrating it is to work with it. I think the bottleneck lays with the processing part (cpu&ram) as there is very little disk access and I/O wait.
Of course, the application is not optimised for speed, but I think paying a programmer to optimise it would cost more than upgrading the machine.
Therefor, my question is: how much IPC improvements were made between Pentium D and Haswell for integers? I would like to estimate how well it would run if I upgraded the machine.

 

[NTMBK]

Well a Pentium D should have the same single threaded performance as a Pentium 4 (given that it is just two Pentium 4 in one package), so there's a couple of comparisons to be made...

http://www.anandtech.com/bench/product/92?vs=1260

On Cinebench the single threaded performance of Haswell is 4X faster. And obviously the Haswell also has twice as many cores as your Pentium D, and has Hyperthreading.

The comparison with Ivy Bridge has many more benchmarks to compare: http://www.anandtech.com/bench/product/92?vs=551

And also the Tech Report did a Cinebench comparison, to back up the Anandtech one:

That Pentium D is insanely outdated. Ditch it!

 

[Chicken76]

NTMBK I saw that benchmark, but I don't think it applies, as Cinebench is floating point mainly. What I'm interested in is integer performance delta between the two.

 

[Ancalagon44]

Clock for clock, I would estimate Haswell to be a minimum of 3X faster at the same clockspeed.

Also, Haswell will have a significantly faster memory subsystem and can clock higher. It would not surprise me if Haswell were to perform the same task 6X faster, without taking the extra cores into account.

With taking the extra cores into account, and especially because you are running your web server and DB server on the same box (not normally advised but I am guessing this is a small scale operation), you could be looking at double that again. So 12X faster, easily.

Plus, lower power consumption will add up in the long run to lower energy bills.

Depending on your needs, I'd also advise you to consider some form of cloud hosting though.

 

[Chicken76]

Based on the Anandtech Bench scores for WinRAR, Excel and Par2 it looks like there's an order of magnitude between them.
I can only say: WOW!
Was expecting a 2x (2.5x at the most) increase, but more than 10x is fantastic!

 

[Denithor]

That Pentium D is insanely outdated. Ditch it!

Agreed. And I would suggest building/buying a system with an SSD. Even if you don't have an I/O bottleneck on the Pentium D system, you very well may on a Haswell system.

 

[Insert_Nickname]

As others have posted, somewhere between 4x-10x faster, depending on workload.

We have a web server running on an old Pentium D and installed recently a complicated web application to be used internally. It's sloooooowww....

I can only imagine...

You defiantly want to ditch something like a Pentium D for server-use. The reduction in power consumption alone is justification enough all on its own.