Jonathan Hilgeman wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
considering moving to a P4 2 Ghz with the same amount of RAM. I have a
few specific tables with several million rows of data, and it takes
quite a long time to process that data on my current server. Does
PROTECTED]
Sent: Wednesday, August 06, 2003 5:00 PM
To: [EMAIL PROTECTED]
Subject: DB Performance - Celeron vs. P4
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and
I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a
few specific
tables with several
well the obvious difference between a celeron and a p4 is the cpu cache,
celerons are good for home linux dev box's, i have 2 now but one only has
32meg and is really slow on the queries but they are cheap and do the job i
i rebuilt one and built another box for about 180 AUD :D , i also have a
scuse the ignorance are u saying high cpu usage is better used on one query
or better be freed up for other queries ? ram is always an issue as the
queries get buffered
Jonathan Hilgeman wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
considering moving to a P4 2 Ghz
The fact that you have several millions of rows may indicate that you
have an I/O problem, not CPU.. do some benchmarking. and perhaps the
solution is going to (if not already) SCSI drives, or some kind of raid
configuration (recommend raid 0+1)
Or if you want to keep costs low.. perhaps using
At 07:00 PM 8/6/2003, you wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server.
Jonathan Hilgeman wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
considering moving to a P4 2 Ghz with the same amount of RAM. I have
a few specific tables with several million rows of data, and it
takes quite a long time to process that data on my current server.
Does
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server. Does anyone have a good idea of