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

Optimize website which runs on a script [ MySQL & PHP ]

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

  1. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    It's a forum type of site I tried to ask the people that made the script and they've turned around and said
    "hey its your host" I'm on a dedicated server and this site isn't even fetching that many users.

    They clearly don't know customer support but I'm not going to sit here and cry about it.

    I need someone that can optimise this site - this is what hostgator said to me about the problem:

    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.

    Your goal would be to optimise it so it doesn't go around in circles like it is at the moment - to improve the speed.

    Leave your message below, I'll select someone that seems up for the job. (Payments to be made through PP)
     
  2. Dante848

    Dante848 Registered Member

    Joined:
    Oct 24, 2012
    Messages:
    59
    Likes Received:
    15
    Occupation:
    Web Developer
    Location:
    Sweden
    If I could take a look at the code I could probably speed it up. I've done a bunch of PHP script upgrades, and one thing I usually had to deal with was optimization.
     
  3. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    Would you need access to the admin panel for this? I need someone that is confident they can take care of it.

    I'm not a developer nor have I got any skills/experiences in that field. Cheers
     
  4. sukataetumba

    sukataetumba Senior Member

    Joined:
    May 25, 2010
    Messages:
    1,109
    Likes Received:
    213
    have you tried it on another host to isolate that issue?
     
  5. Dante848

    Dante848 Registered Member

    Joined:
    Oct 24, 2012
    Messages:
    59
    Likes Received:
    15
    Occupation:
    Web Developer
    Location:
    Sweden
    It really depends on the script, how interactive it is with the server and other files on it. If it is a shallow script, probably not.
     
  6. MrBlue

    MrBlue Senior Member

    Joined:
    Dec 18, 2009
    Messages:
    950
    Likes Received:
    662
    Occupation:
    Web/Bot Developer
    Ask your host to enable MySQL slow log, if it isn't already, and have then provide you a copy. With this log you will be able to determine which queries are causing bottlenecks.
     
    • Thanks Thanks x 1
  7. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    I'll do this right now =) thanks a lot!
     
  8. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    I went from WiredTree to Hostgator both packages were on a dedicated server costing more than $100 a month.
     
  9. melvinn

    melvinn Newbie

    Joined:
    Nov 24, 2011
    Messages:
    30
    Likes Received:
    1
    The fastest solution:

    1. Enable more request on mysql, go on stackoverflow and read on how to do this. It will take a couple minutes
    2. If you are actually getting too many request, consider doing a master-slave scenario. Clone your db to other servers to serve your db.

    Optimizing the code really depends on a lot of things. The number of reads, can we some how cache it?
     
  10. xiMe33

    xiMe33 Junior Member

    Joined:
    Feb 24, 2012
    Messages:
    194
    Likes Received:
    38
    What script do you use?
     
  11. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    Unfortunately I do not understand computer language.

    Let's pretend BHW is the website we are talking about - every time a thread is clicked, the website takes 2-5minutes to load up the page it's confused it doesn't pick up that URL right away it must be doing something.

    what do you mean by too many requests? right now the website gets a maximum of 10 people live mode on g.analytics - it used to take 400+ at one time without any problems? I don't know what happened. Same hosting, same plan .. everything.
     
  12. Dante848

    Dante848 Registered Member

    Joined:
    Oct 24, 2012
    Messages:
    59
    Likes Received:
    15
    Occupation:
    Web Developer
    Location:
    Sweden
    If you aren't getting that many visitors and it is still taking to much time to load, it is surely the code placement, I see it a lot with PHP. Also, you could try using CloudFlare. The DNS takes only a minute or two to move over, and the speed increase is dramatically better.
     
  13. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    CloudFlare? is that a hosting company even if I do move my coding will be the same? I'm a complete newbie at this. that's why I wanted someone to get this misery over and done with ^_^ unless there was a simple way for me to make it faster I'd do that right away
     
  14. Zakhar

    Zakhar Power Member

    Joined:
    May 17, 2011
    Messages:
    670
    Likes Received:
    110
    Occupation:
    - Entrepreneur in the making.
    Location:
    I'mFromPluto
    I have the SQL slow log, as MrBlue said above - if someone can take a look at this? let me know!

    Cheers
     
    Last edited: Mar 3, 2013