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 >anyone have a good idea of the type of performance increase I'd see if >I moved to a P4 server?
It's going to depend of in your queries are disk bound or processor bound. Check the processor usage when a big query is running (and not much else is running). If the CPU usage is at 80-100% the query is processor bound, so you'll see some improvement (though I can't tell you how much, other than the clock rate scaling). On the other hand, if the CPU usage is low, you are likely disk bound, so a faster processor won't help much. It would be better to add RAM, tune your queries or get faster disks (or all three) in this case. --Ware Adams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
