Tom's Hardware > Forum > CPU & Components > CPUs > Which old socket 478 CPU for database work

Which old socket 478 CPU for database work

Forum CPU & Components : CPUs - Which old socket 478 CPU for database work

Tom's Hardware: Over 1.4 million members in 6 different countries available to answer all your high-tech questions. Sign up now! Its free!
Ask the community Add a reply
for database work, which is better


 
0.0 %
      0 vote
Celeron D 335 Prescott (2.8GHz - 533MHz FSB - 256KB L2)
 
100.0 %
      6 votes
Pentium 4 2.8 Northwood (2.8GHz - 800MHz FSB - 512KB L2)

All : 9 votes (3 blank votes)

This poll is closed, you cannot vote

Word :    Username :           
 
oz-dingo   08-23-2008 at 09:14:09 AM

Hi all

I was wondering for an office environment where the main work will be database transactions on Windows XP, which processor would be better suited? Or would this task not matter much?

If there is no winner on performance, which would be better in terms of power efficiency or heat output? I've heard Prescotts with 1MB or 2MB cache are really bad, but Celerons are a different kettle of fish and apparently are OK in temperatures?

I see the Celeron D has more L1 cache, but less L2 cache and a lower FSB. However, it benefits from improved architectural design (http://www.anandtech.com/printarticle.aspx?i=2093). It also has SSE3 compared to none in the Pentium 4 and I've heard these are important considerations.

The cost is the same, so that's not an issue. I just don't know which to go for.. help me decide with this poll!

Thank you :pt1cable:

Message quoted 1 times
Add a reply
Sponsored Links
Register or log in to remove.
jaywalker256   08-23-2008 at 09:32:46 AM
- 0 +

Id probably bet on the Northwood, but you probably arent going to notice a huge difference between the two. If you can, just run some tests on em both. Heat/Power will probably be similar. I dont think its going to make a terribly big difference since they both kinda suck anyway...

------------------------------ Please Check Out My Site:

Blue Spear Application Development
 Reply to jaywalker256
croc   08-23-2008 at 11:08:46 AM
- 0 +

oz-dingo wrote :

Hi all

I was wondering for an office environment where the main work will be database transactions on Windows XP, which processor would be better suited? Or would this task not matter much?

If there is no winner on performance, which would be better in terms of power efficiency or heat output? I've heard Prescotts with 1MB or 2MB cache are really bad, but Celerons are a different kettle of fish and apparently are OK in temperatures?

I see the Celeron D has more L1 cache, but less L2 cache and a lower FSB. However, it benefits from improved architectural design (http://www.anandtech.com/printarticle.aspx?i=2093). It also has SSE3 compared to none in the Pentium 4 and I've heard these are important considerations.

The cost is the same, so that's not an issue. I just don't know which to go for.. help me decide with this poll!

Thank you :pt1cable:



You are asking for a simple answer to a rather complex question.
1. What database?
2. How many transactions / sec. do you expect?
3. How many tables will the database use?
4. How many fields per table?


Reply to croc
ke7diz   08-23-2008 at 08:46:32 PM
- 0 +

go p4 unless you have the ability to test the platforms.
the sse3 could make a small dif but generally the celrons are a low end possessor.
also unless you have a connection fore used cpus or something the p4's and celron d's are more expensive than they are worth so if you can go cheap duel core

Reply to ke7diz
oz-dingo   08-26-2008 at 12:52:09 PM
- 0 +

Hi croc,

thanks for the reply. Not sure on those details unfortunately.

5 votes is enough for me, Northwood it is!

Reply to oz-dingo
Ask the community Add a reply
Tom's Hardware > Forum > CPU & Components > CPUs > Which old socket 478 CPU for database work
Go to:

There are 1028 identified and unidentified users. To see the list of identified users, Click here.

Forum map
Bestofmedia Forum ©
2000-2009 Bestofmedia Group
Page generated in 0.339 seconds
Please mind

You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.

Add a reply Cancel
Sponsored links
  • Ask the community now
  • Publish
Ad
They won a badge
Join us in greeting them