Need Database Expert For Large Database Site

Discussion in 'Programming' started by AjOnline, Sep 10, 2010.

  1. #1
    I have a site that has a large database for some users there pages aren't loading at all. Also in the admin there is alot of slow loading pages or pages not loading at all. This has a large database and it is growing all the time. So I need someone that can fix all of this. Here is some notes from another programmer that reviewed the site. Please send me a pm with your thoughts.

    As your site grows the database will grow and the way the site is coded is not optimized for a large database. I expect the site will completely fail with the current code once the stats database grows to 5 million rows or more.


    The entire site needs to be recoded so that it uses delayed inserts rather than update queries, and then a cron job should be used to compile stats data periodically.
     
    AjOnline, Sep 10, 2010 IP
  2. shaams

    shaams Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    @AjOnline first kindly describe the website infra structure such as :

    Web Server
    Database Server
    Hosting information.

    then any developer can help you out.
     
    shaams, Sep 12, 2010 IP
  3. Tahity

    Tahity Well-Known Member

    Messages:
    215
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    165
    #3
    Hi, i have alot of experience in working with large amount of datas and building huge applications. Please contact me via IM or email so we can discuss further. thanks
     
    Tahity, Sep 13, 2010 IP