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

Optimize MySQL & PHP website

Discussion in 'Hire a Freelancer' started by Zakhar, Mar 26, 2013.

  1. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    I'm a complete alien when it comes to developing, always outsource.

    I have a website that has been running slow for almost a month now.

    This is the chat log from HG:


    Jesse H.:MySQL & PHP are causing the high load. It looks like you need to further optimize to prevent this.
    Jesse H.: /home/zakhar/public_html/administrator/members_manage.php
    Jesse H.: /home/zakhar/public_html/view.php
    Jesse H.: /home/zakhar/public_html/account.php
    Jesse H.:We are not trained on code optimization, so you will need to have someone evaluate the code and let them know it is causing your site to have high loads and run slowly or complete cause the site to time out.

    ^ Again, don't even ask me what the above means - that's basically the problem.

    I have set up an FTP host thingy for whoever knows how to fix this to access the code - please keep in mind its not a website I made from scratch I bought the theme/template.

    I want the speed to be improved as right now it takes around 30seconds to load page to page which is highly unprofessional, it was once going at lightening speed.

    It's on a dedicated host - so the hosting is not the issue for certain.

    Please send me your PM's or post below - whichever way you wish, thanks.

    P.S - Try not the over-price yourself, I know exactly how much I should be paying for a job like this.
     
  2. hustleharderrrr

    hustleharderrrr Junior Member

    Joined:
    Jan 2, 2012
    Messages:
    109
    Likes Received:
    33
    Location:
    Bugatti Pure Sang
    But you don't know what the issue is? Nice joke :ranger:
     
  3. kuzmanin

    kuzmanin Regular Member

    Joined:
    Jul 17, 2010
    Messages:
    386
    Likes Received:
    45
    You mentioned mysql
    In most of the cases the real problem is there
    Do you have access to mysql config?
    If yes I will be happy to take a look at this problem.
     
  4. dataengineer

    dataengineer Newbie

    Joined:
    Feb 17, 2013
    Messages:
    29
    Likes Received:
    2
    I can sort it out. Contact me S K Y P E: ifacedev
     
  5. primadg

    primadg Junior Member

    Joined:
    Dec 19, 2012
    Messages:
    101
    Likes Received:
    9
    Looks like your problem is in MySQL DB.

    It could be:
    - the tables without indexes.
    - not optimized DB requests

    PM me for skype info

    My best regards,
    Valera
     
  6. vikasvyas47

    vikasvyas47 Power Member

    Joined:
    Dec 6, 2011
    Messages:
    523
    Likes Received:
    4
    hello
    i have good experience in php and mysql add me on skype for further detail talks

    skype : vikasvyas47
     
  7. lancis

    lancis Elite Member

    Joined:
    Jul 31, 2010
    Messages:
    1,632
    Likes Received:
    2,384
    Occupation:
    Entrepreneur
    Location:
    Milky Way
    Home Page:
    What caused the change in speed?
    Did you order a redesign? User base grow? Anything else you can point at?

    30 seconds is a lot of time even for the worst of PHP scripts. Usually MYSQL requests are the ones to cause this. Ask your hoster to activate the slow query log (details here http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html) and if mysql is the cause you'll know where to fix.