1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

DB Load Time URgent Please Help customers getting angry

Discussion in 'General Programming Chat' started by wseo12, Feb 16, 2012.

  1. wseo12

    wseo12 Regular Member

    Joined:
    May 23, 2009
    Messages:
    221
    Likes Received:
    7
    Occupation:
    FUll TIME IM
    Hi have been having a serious problem i have huge a database over 116,290 pages you do the math how many rows thats is millions

    My whole problem is the user end is taking about 30 seconds to load becouse the db is so big and db is only becoming larger as each day goes on

    what can i do to reduce the db load say to under 5 seconds or something like that i really need your help my customers are getting very angrey

    Some on please help me
     
  2. wseo12

    wseo12 Regular Member

    Joined:
    May 23, 2009
    Messages:
    221
    Likes Received:
    7
    Occupation:
    FUll TIME IM
    i really need some ones help here this is an urgent issue you will be given rep an thanked
     
  3. UltraLink

    UltraLink Regular Member

    Joined:
    Dec 29, 2011
    Messages:
    343
    Likes Received:
    192
    Location:
    West Palm Beach
    Home Page:
    1.) Are your major queries cached? That can really help speed things up.

    2.) Are the server resources struggling to keep up? Might want to upgrade them.

    3.) Check for redundancy. Avoid using queries in loops.


    There are many ways to optimize, it all depends on the existing code.
     
  4. indianbill007

    indianbill007 Jr. VIP Jr. VIP

    Joined:
    Jan 8, 2010
    Messages:
    4,813
    Likes Received:
    4,051
    Occupation:
    Making Money when the world is sleeping
    Location:
    Menlo Park - Next to Zuck