What do I need to upgrade to increase my site speed

Discussion in 'Databases' started by kezhu911, May 30, 2009.

  1. #1
    my website is working very slow, and I am using dedicate serve, I just wondering what should I upgrade to get rid of the slowness:)
     
    kezhu911, May 30, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    First you need to figure out exactly what is slow. There could be a number of areas that are bottle necking your site. Database, internet connection, dns, scripts, etc...
     
    jestep, May 30, 2009 IP
  3. kezhu911

    kezhu911 Peon

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I have 2 website in my data base, the first one which I been using for a while, the log usage is only 30, and its really fast to connect to it, but my 2nd website log usage is 200, it have alot error logs , and it load really slow, so I think it might be where the problem is
    first site is plain html site, not much php scripts invole
    2nd one is written with lots php scripts, have lots jpg loads, external links, so could that cause the problem, cause that's what the error log message are.
     
    kezhu911, May 31, 2009 IP
  4. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #4
    Did the performance-related issues start when you installed the 2nd website? Can you post some of the errors? The errors might provide useful information, so we can offer some suggestions.
     
    Social.Network, May 31, 2009 IP
  5. kezhu911

    kezhu911 Peon

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    it starting to lag when there is about 5k visitor , but 1st website still load fast, no problem at that time, just the 2nd one

    [Sun May 31 00:30:09 2009] [error] [client 61.18.186.132] File does not exist: /home/website/domains/website.com/public_html/photo/2586243.jpg, referer: http://www.website.com/hosted-74-\x...4\xbb\x96\xe6\x8f\x92\xe4\xb8\x80\xe6\xac\xa1
    here is one of the error, and all the errors are same
     
    kezhu911, May 31, 2009 IP
  6. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #6
    This is an IO error, which may not necessarily be affecting performance. It is tough to guess based on only the above information. Any other members want to comment?
     
    Social.Network, May 31, 2009 IP
  7. javafreak

    javafreak Peon

    Messages:
    75
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Have you verified that the proper index(es) have been created for the 2nd database?
     
    javafreak, Jun 3, 2009 IP
  8. neegeris

    neegeris Banned

    Messages:
    73
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    You need update ram and cpu
     
    neegeris, Jun 10, 2009 IP
  9. hemanthpammu

    hemanthpammu Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Hi Dude, If you are good at your coding stuff, go for AJAX. If you use this, you can get the data from webserver without reloading the page. The AJAX technique makes Internet applications smaller, faster and more user-friendly.
    The components that effect the performance:
    65% - Application Design
    25% - Data Base Design
    5% - Your DBMS system
    5% - OS.

    Jus think of it.
     
    hemanthpammu, Jun 10, 2009 IP
  10. LH-Danny

    LH-Danny Member

    Messages:
    398
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    35
    #10
    Why are you running a dedicated server when you don't even know what is slowing your site down? Hire a system administrator for yourself.
     
    LH-Danny, Jun 10, 2009 IP
  11. bluebenz

    bluebenz Well-Known Member

    Messages:
    876
    Likes Received:
    9
    Best Answers:
    2
    Trophy Points:
    138
    #11
    If I were you, then I'll do a test on other server.
    some server is slow..
     
    bluebenz, Jun 10, 2009 IP
  12. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #12
    There is another side to this statement, use Ajax and increase server overload.
    For example you search on a search engine, after each character you type it gives you a short list of possible keywords. This shortlist per character typed is actually a request to you webserver. So in essence if your current design has a scalability issue any additions in the form of extra queries due to ajax will give you more load.
    But I agree wholly with the priority list, OS en DB vendor are not the most relevant items for performance DB design and app design are, you might call the last two your systems architecture and that is what defines your performance/scalability.

    As an indication define possible performance increase by tuning/changing:
    Factor 1-2 -OS
    Factor 1-5 -Your DBMS system
    Factor 5-20-Data Base Design
    Factor 5-10000- Application Design
     
    chisara, Jun 12, 2009 IP