-1

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 !

Improve this question
9
  • I don't see, where this is related to c#, java and php! Beside that it belongs to ServerFault.com IMHO
    – user24013
    Jul 8, 2010 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, 2010 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, 2010 at 9:07
  • if i can easy add a server ,then it's not a problem ...
    – Hooligan
    Jul 8, 2010 at 9:08
  • Do you have a url I could analyse the performance and bandwidth requirments of?
    – Duncan
    Jul 8, 2010 at 9:08

3 Answers 3

Reset to default
3

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.

Improve this answer
3
  • 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.

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

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .