Could you please review my website

Discussion in 'Websites' started by komrad, Apr 25, 2014.

  1. #1
    Hello all,

    I have a website its about price comparison site
    The url is http://mypricecompare.com

    I really care about website loading speed. Could you test open it from your location?
    Your help really appreciated.

    Thanks in advance.

    Asep
     
    komrad, Apr 25, 2014 IP
  2. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #2
    You can also try to search on it. Try any product name, then it will come up with products in database.
    I see that the speed is very slow. What do you think should I do to improve it?
     
    komrad, Apr 25, 2014 IP
  3. carlo75

    carlo75 Active Member

    Messages:
    129
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    80
    #3
    Hi komrad,
    yes you're right. For loading the watch page comparison about 30 seconds. Sometimes good response if I use the search function: ebook (0.8 sec), lcd (48 sec), watch (36sec) [Europe]
    I think we need more information to understand where is the problem.

    Have you programmed the comparison software or using some commercial script?
    You query a database, a xml file or directly fetch the affiliated store?
    Are your site running on shared hosting?

    Moreover, according to your website's competitors, I think your site need a better cool look and a new logo.
     
    carlo75, Apr 25, 2014 IP
  4. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #4
    Hi Carlo75,

    Thanks for your review.

    The data fetch from mysql database query. and I'm using vps with ssd drive in it and 1 gb ram.
     
    komrad, Apr 25, 2014 IP
  5. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #5
    And I'm using commercial script from pricetapestry . com
     
    komrad, Apr 25, 2014 IP
  6. carlo75

    carlo75 Active Member

    Messages:
    129
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    80
    #6
    Mmmh this sound as a slow database query performance...
    I've tried a search on their site, and there are a some results:

    https://www.google.it/search?q=site%3Awww.pricetapestry.com+slow+search&oq=site%3Awww.pricetapestry.com+slow+search&sourceid=chrome&es_sm=93&ie=UTF-8
     
    carlo75, Apr 25, 2014 IP
  7. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #7
    Thanks carlo75,

    I'd like to check it now.
     
    komrad, Apr 25, 2014 IP
  8. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #8
    Allright, I've updated my server configuration by installing APC and Varnish. Seems like the site loading become faster now.
    Let see how is it going now..
     
    komrad, Apr 25, 2014 IP
  9. carlo75

    carlo75 Active Member

    Messages:
    129
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    80
    #9
    Mmm I can't find some speed improvements... APC and Varnish are already working?
    Try to cache also the database query for the watch in home page...
     
    carlo75, Apr 25, 2014 IP
  10. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #10
    Try to cache also the database query for the watch in home page <-- How to do that?
     
    komrad, Apr 25, 2014 IP
  11. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #11
    komrad, Apr 25, 2014 IP
  12. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #12
    Done on mysql caching... How about now carlo75?
     
    komrad, Apr 25, 2014 IP
  13. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #13
    memchaced installed as well. looks faster now...
     
    komrad, Apr 25, 2014 IP
  14. carlo75

    carlo75 Active Member

    Messages:
    129
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    80
    #14
    Hi komrad, sorry for delay,
    YES now all works like a charm!!! You have done a great job on improvements speed!
     
    carlo75, Apr 26, 2014 IP
  15. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #15
    Now I'm thinking about design. Phew!! Will do it later tho. :D
     
    komrad, Apr 26, 2014 IP
  16. Annea

    Annea Well-Known Member

    Messages:
    335
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    138
    #16
    Loads fast from Ontario, Canada. I searched for "bicycle" and the page came up really fast!

    Wish I knew how to do that stuff. :( Make a site faster, I mean.
     
    Annea, Apr 26, 2014 IP
  17. carlo75

    carlo75 Active Member

    Messages:
    129
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    80
    #17
    Komrad has done a very pro job with APC, Varnish and Memcached and caching database querying.
    So really a showcase... from turtle to cheetah ;-)
     
    carlo75, Apr 26, 2014 IP
  18. tuppence

    tuppence Member

    Messages:
    131
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    40
    #18
    Hello
    I just tested your site from the UK and although the basic product search is fine when I tried to get more information on the products it was very slow (over 15 seconds) which would have been enough time for a buyer to leave the site. I tried this on a few tines and it was the same for all. Hope this helps.
     
    tuppence, Apr 26, 2014 IP
  19. tuppence

    tuppence Member

    Messages:
    131
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    40
    #19
    I did a further test and it seems the slow load may be from the referring site

    A search for kettle threw up near instant further info from Amazons offering however a when searching for a wishbone chair the further info from total furniture took 10 seconds plus. Similar experience with soap shampoo and alloy wheels (a pretty random mix).
     
    tuppence, Apr 26, 2014 IP
  20. komrad

    komrad Notable Member

    Messages:
    2,539
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    230
    #20
    Hmm... The images are from the merchant/referring site, but not the title and product's description.
    I think this issue lies on php code as well. Thanks for review tuppence! I will check the php code issue.
     
    komrad, Apr 26, 2014 IP