What do you think would be a better route for a server? I need a server that can handle a lot of mysql queries.
I would also..I've had some good results with the dual xeons and mysql (I run a dual xeon ad server with phpadsnew). Just get extra memory. Then some more memory. Otherwise you'll be kicking yourself later on.
Yeah I run a large teen rating site with very active forums 2,000,000+ post and such do you think 4gb is good or do you think 2gb would be enough?
Go with the dual xeon and the 4 GB of RAM can only help, not hurt (except for the expense). How much extra is the 2GB of additional RAM?
I'm with Dual Xeon and 3GB Ram, never used a HT before but I was closed to using it. LOL. Dual Xeon has been great so far. No problem at all!
Dual Xeon - I'm no expert but I believe you'll find that'll give you 4 Xeon processors, whereas a Dual pentium with HT will give you 4 P4 processors (I think). So definitely go with the Xeons. Also take the 4gigs of ram. With that volume you need eveything you can handle. And - this may be obvious, but it may not - make sure the kernel you have installed is actually compiled for dual processor systems. Without that being done you'll only ever use one processor.
Dual Xeons all the way. We have a few busy forums and before we switched to Dual Xeon 3.2's we had constant issues. Since the switch we've had extremely good results. Also helped that we seperated the web server and MySQL server between 2 servers with a 100Mbps private LAN set up between them to handle the queries. Private LAN does a fairly constant 25-30Mbps and both servers have load averages under 0.50 pretty much all the time.
Definetly dual xeons. Xeon processors should not be compared to desktop processors. Xeon processors are made to handle load better -- they are enterprise level equipment, where as the standard P4 is not. Also, if the chips are the new dual core woodcrest xeons they will perform very well. Xeons all the way!
get opterons if you can.Dual.Those are the best for boards, like some tech guy from the vBulletin staff showed. see here