Which one is the better CPU?

[Guest]

Help please!!!
My old CPU is a
Intel Pentium 4 3.06Ghz Dual Core
with system bus of 533Mhz,
RAM of 2 x 512DDR, on a 40Gb ATA HDD.

and
the new CPU is a
Intel Pentium D 2.8Ghz Dual Core
with system bus of 800Mhz,
RAM of 1 x 512DDR2, on a 80Gb SATA HDD.

Which one is the better CPU when i used it as my SQL 7.0 Server and printer
server in the same time? Both are installed with WIN 2000 Server, load for
the SQL 7.0 will be 18 users connected in the same time also?

Thanks!

Richard

 

[JCO]

The big difference it Pentium 4 vs D. Therefore, it depends on the function
of the PC. Pentium D is a dual core processor. While the P-D (2.8Ghz)
CPU's are much slower than the P-4 (3.06Ghz), it depends on the usage. If
your using it as a true multithreading type applications (running multiple
things at one time) then you might get a better performance on the P-D.
Most computers sit idle so much because they are not pushed to their limit.
In that case, the P-4 may be faster. It just depends on how hard you plan
to push the PC.

Maybe someone else will have some stats for you... I don't. Sorry

 

[JCO]

Read this too:
http://www.neoseeker.com/Articles/Hardware/Reviews/pentium-d-820/

 

[Stubby]

The CPU speed won't make a noticeable difference unless you are
CPU-bound, say computing the billion-th digit of pi. Almost no systems
are CPU limited, however.

Interactive jobs are limited by how fast they can move disk blocks in
and out of memory. This is a physical limit so you want to get the
fastest, high-RPM drive you can afford. SATA, EIDE, SCSI, etc
interfaces will not make a difference. But if you could get one of
those 10,000 RPM Hard disks, you'll feel the difference in your fingers.

The other thing to do is add as much memory as you can. Windows will
use some of it for a disk cache, giving the illusion of a fast disk.

So, the "old" system wins by a hair.