Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We developed a website, and recently we found that our website was overloaded:

  1. One single server can not process all requests effectively.
  2. Our database can not save all the data, and the connection is usually not enough.
  3. Our network bandwidth is not enough for all request.

I want to know how can we solve these problems ? What is the popular ways of solving these ?

Thanks in advance !

share|improve this question

migrated from stackoverflow.com Jul 8 '10 at 9:10

This question came from our site for professional and enthusiast programmers.

    
I don't see, where this is related to c#, java and php! Beside that it belongs to ServerFault.com IMHO –  user24013 Jul 8 '10 at 9:04
    
The answers to the second part of q2 and q3 of are easy enough: upgrade your connections. I also wonder if the answer to q1 is caused by db overload or the webserver itself is groaning? –  spender Jul 8 '10 at 9:07
    
These are 3 different problems it seems. Adding servers can be a solution for 1 and 2 but if the problem comes from the application architecture then you are just relaying the issue to the future. For 3 buy more bandwith and/or reduce the number of requests needed per user. –  Redlab Jul 8 '10 at 9:07
    
if i can easy add a server ,then it's not a problem ... –  Hooligan Jul 8 '10 at 9:08
    
Do you have a url I could analyse the performance and bandwidth requirments of? –  Duncan Jul 8 '10 at 9:08

3 Answers 3

up vote 3 down vote accepted

A few dead-tree recommendations to help you in the long run:

There are several websites that outline Steve's performance guidelines that you can easily find through a Google search. Most of them will help reduce the number of requests and speed up the remaining ones. Theo's book, however, is invaluable in regards to building out scalable systems and I highly recommend giving it a read. John's book is a quick read but will give you insight into how to plan for future expansion.

share|improve this answer
  • Get a faster computer for frontend
  • Get a faster computer for the database
  • Get a faster network connection

Yeah, all of those cost money. But probably less money that going through all your code to optimize it, unless you have a some massive inefficiencies that are easy to pinpoint. But if everything (web server, DB and network) is overloaded, it doesn't sound like it.

share|improve this answer
1  
On the flip side, almost everyone has some massive inefficiencies hiding somewhere :) –  hobbs Jul 8 '10 at 9:09
    
if i can easy add a server ,then it's not a problem –  Hooligan Jul 8 '10 at 9:10

It may be possible to reduce your bandwidth requirements and reduce your server load by reducing HTTP Requests by a number of simple performance tweaks. Setting far-future expiration dates on static content, combining files like css sprites, combining javascript and css. You could also do with outsourcing jQuery and other Javascript libraries to Google using their free Google AJAX Libraries API.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.