Why is my Page execution time slow?

Discussion in 'MySQL' started by entrecast, Apr 22, 2009.

  1. #1
    My Page execution time was "1560.97 ms." I have seem other websites with the same niche "Page Generation time is 0.02 Seconds" I want my load time to drop around that! Any help or suggestions is appreciated, thanks in advance!

    My website
     
    entrecast, Apr 22, 2009 IP
  2. pitagora

    pitagora Peon

    Messages:
    247
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #2
    There are two possibilities:

    1. The script you use is inefficient and unprofessionally made. This is what happens when every kid can learn PHP and convinces clients he's a guru
    2. The server your website is hosted on is under high load, possibly indicating a big overselling host.

    In any case 1560 ms is a lot of time. To make a little comparison my IIS dedicated server (512 MB RAM, Windows 2003 Server) under normal conditions:

    That's a hell of let of queries in half the time..... My bet is on nb 2.
     
    pitagora, Apr 22, 2009 IP
  3. 007c

    007c Peon

    Messages:
    611
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Could also be the script is making hostname lookups and the dns servers are badly configured.
     
    007c, Apr 22, 2009 IP
  4. fubaba

    fubaba Member

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #4
    difficult to advise smth untill you provide more details
    if you page uses a huge tables and makes complicated grouping actions that it may be a good run time
    otherwise:
    1). check indexes (if you create and they are used - with mysql explain operator)
    2). use higher buffer sizes in mysql config
     
    fubaba, Apr 23, 2009 IP
  5. Nathan Malone

    Nathan Malone Well-Known Member

    Messages:
    369
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    110
    #5
    Have you gotten this issue resolved, yet?

    Since you're apparently hosting with 1AND1, if you had an inefficient query that was dragging the server down, my guess is that they would have notified you of it, and temporarily suspended your hosting account.

    As fubaba said, in many cases (especially with custom software written by new developers), there are no indexes in place on database tables, which will really kill performance once you get some decent traffic hitting the site.

    Anyway, if you're still having issues with it, you'll probably need to send server login info to someone to take a look at it, as there is only a limited amount of help we can provide without access to the server and files.
     
    Nathan Malone, Apr 28, 2009 IP
  6. feras80

    feras80 Well-Known Member

    Messages:
    302
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    110
    #6
    the header image is 88 KB.
    another image on the left is 97 KB
    footer image is 69 KB
    you may optimize these images or use CSS instead.
    also, you have couple of missing JS files.
    good luck
     
    feras80, Apr 28, 2009 IP
  7. entrecast

    entrecast Peon

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Thanks you all for all your input; however, I am going a different direction with the site. Just a minor face lift of the home page created in CSS, I hope that would also help with "page execution time!"

    @pitagora
    1. I can assure you it was very well created and thought-out, but second and third eyes at greatly needed. As you can see out off the total 5 responds everyone has a different opinion.
    2. I would consider your right about the hosting. 1and1 is saturated with thousands of customer and websites, their are a big hosting company. I thinking about changing hosting company any suggestions? Thanks for your input an I am opening for any other suggestion you may have.

    @007c Humm, not to sure what you mean, can you clarify?

    @fubaba To be honest I am not the one how made the site or the database, I have a coder who built it for me. His availability is very limited and he also is stump on configuring the site to lower the time.

    @Nathan Malone YES, I am still having trouble! I send you an PM. I hope you can help.

    @feras80 Humm, good observation I am currently looking for a great design for the site. I want to completely replace the Durpal theme. If you know of any great CSS designers please send them to me!

    Again thank you all for all your advise and input...Please if you have any more suggestion please post or PM
     
    entrecast, Apr 30, 2009 IP
  8. T.Guru

    T.Guru Peon

    Messages:
    78
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    What has been said here is pretty much true. I would add that having a heavy index is going to make your page open slower. Images need to be optimised. Your database needs to be less heavy... Try to make it as light as you can.
     
    T.Guru, May 12, 2009 IP