Avatar of palserv
palserv asked on

Which Specification better??

Hello,
I Have 2 servers i want to know which one its better  for webhosting solution

First Server :
Processor : Dual Processor Quad Core Xeon 5430 - 2.66GHz (Harpertown) - 2 x 12MB cache
Memory : 4GB RAM
HDD : 2 x 250GB SATA
Port : 100mbit/s
Location : Dallas, TX - Central U.S.


Second Server :

Processor : Dual Processor Quad Core Xeon 5405 - 2.00GHz (Harpertown) - 2 x 12MB cache
Memory : 4GB Ram
HDD: 2 x 300GB SAS 15K
Port : 100mbit/s
Location : Washington, DC - East Coast U.S.

which one is better ??
LinuxLinux DistributionsApache Web Server

Avatar of undefined
Last Comment
Lee W, MVP

8/22/2022 - Mon
omarfarid

I will go for the 1st one with more processing power.
The 2nd option has more disk space and could be faster disks.
ASKER
palserv

which is best for sql DB , theres now load but very slow when order?
omarfarid

I will go with the 1st choice
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Lee W, MVP

I would say it depends on exact usage.  If you use static web pages or run a database off another server, than I would go with the first one.  If you run a dynamic web site with database driven web pages and those web pages are on the same server as the database, then I'd go with the faster drives.  It's a lot easier to upgrade CPU than it is to upgrade hard drives.
ASKER
palserv

the web server and DB in same server , so that you recommend the second choose ?
omarfarid

leew:

modern databases will cache data in ram (the most wanted) and this will make it faster to serve. I have mentioned this in my previous comment. Faster disks will help as well.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
palserv

can i go for second choose!!!!!!!
omarfarid

Well, it is your choice after all :)

If the disk space and speed are the important factors for you, then yes.
ASKER
palserv

all of this to improve db speed and web server speed
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
omarfarid

Ok, but the CPU speed is a factor as well.
Lee W, MVP

That's true... but we don't know what databases they are using or what transactions will be used.  Or for that matter what OS they will be using (64 bit vs. 32 bit).
Lee W, MVP

Well, by saying you want to "improve ... speed" suggests that you have systems currently in place... so... have you determined what your bottleneck is or are you just trying to guess which will help you most?

If it turns out that your current CPU isn't pegged then it would be foolish to try to improve that.... you would get little if any benefit.  Before you go throwing money at something, do some analysis on your systems to determine what the cause of your performance issues are...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
palserv

the system running under Linux CentOS 32bit, 95% of DB for forums, and some websites scripts
ASKER
palserv

also the server running ander cPanel
www.cpanel.net
Lee W, MVP

That's fine... what KIND of database?  MySQL, Oracle, something else?  A true modern system or a file-based system... but really, the important information is not what you expect to run... it's how it's performing now with the hardware your using.  It's foolish, truly foolish in my opinion, to throw money at a solution when you don't even know what problems you have right now.  Determine your bottlenecks NOW and buy a system that best addresses those bottlenecks... and don't narrow it down to one config or another... I don't know why you're asking the question you are, but I guess I don't understand why your so eager to throw money away on narrow options.  Most vendors will build a relative custom system for you.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
palserv

Mysql DB , im rented this server in SoftLayer DataCenter ,
Lee W, MVP

ok... you still haven't answered the key question - what are your bottlenecks NOW.
ASKER
palserv

the bottlenecks in DB take high load
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Lee W, MVP

but is it a load on the CPU or Disk?  Why is this a hard question?
ASKER
palserv

both
ASKER CERTIFIED SOLUTION
Lee W, MVP

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question