• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Athlon 750MHz faster than P4B2.4?

BCinSC

Platinum Member
Running a database upgrade program. The Athlon system completed 13 months of data in 3hrs 20min. The P4 is at 4 hrs and only completed 9 months so far. All other factors equal except P4 has twice as much RAM and a newer, faster drive. Really surprises me.
 
Supposedly, Svr2003 has MUCH LESS, since most services are disabled by default. It's TaskMan has less listed than NT4 box.
 
P4 is grinding 2002 data and Athlon grinded 2003. Pretty much identicle. If anything, Athlon had more to grind.
 
Maybe the data work itself just run nicer on an AMD processor? Surprising to see that much difference.... Maybe for a lark you could switch the two jobs after they're done to compare? 😉
 
Just because there is more doesn't mean that it will take longer to crunch. What is it doing to the data? Could there be corruption in the data? Does it have to be manipulated in a different way?

As an example we have an app that parses through 300MB of logs every morning. It take about an hour to run through it all. We have another app that parses through 1Gb og logs but it finishes in about 15 minutes because it does a lot less with the data.

Can't use this as a benchmark if it's two different data sets.
 
Something just doesn't sound right here. There's no way on earth that, all else being equal, the P4 gets it's hat handed to it on a database operation. There MUST be some key difference in the disk subsystem that is slowing the P4 system down. Perhaps no IAA drivers or improper IDE controller setting?
 
Run the test with both having up to date drivers and both using the exact same data.
There's just no way A 2.4B is going to lose to a Athlon 750.
 
P4 is a Dell PowerEdge 600SC which seems to operating correctly - completes DC projects just fine (yes they were disabled during DB upgrade).

Ahtlon is a no-name beige box.

Would network overhead have much impact? P4 was connected, but Athlon was not.
 
Does the P4 run any other services on it? Are there other databases on this server running while the test is running?
 
Back
Top