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 dual 533 celeron on a classic ABIT BP6 board i built 3 years ago running XP it renders audio pretty well but falls apart sometimes.
> 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 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] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]