Post by lemonadv » Fri Apr 08, 2016 4:42 pm

I have OpenCart 1.5.6 installation with 400 categories and 10 000 products.
When I check the website speed with Google PageSpeed Test i got:
82/100 points but this problem appear:

Reduce server response time

In our test, your server responded in 1.2 seconds. There are many
factors that can slow down your server response time.Please read our
recommendations to learn how you can monitor and measure where your
server is spending the most time.

The website is hosted on VPS/4vCore/4GB RAM

I already do all the fixes about speed that I found on the internet.

Enable Gzip cahce.
Mimify CSS and JavaScipts
Optimize database add indexes
Leverage browser caching
Enable memcached

Here is my GTMetrix score:

PageSpeed Score: A (93%)
YSlow Score: C (78%)
Page Load Time: 2.4 sec
Total Page Size: 1.07 MB
Requests: 69

Could you please some one give an advice what I have to do more to
reduce server response time to 200 ms as it said by Google?

Newbie

Posts

Joined
Fri Apr 08, 2016 2:53 am

Post by oc-extensions » Mon Apr 11, 2016 1:06 am

Hey lemonadv, where is the server located ?

Image | Extensions and Custom Development


User avatar
Active Member

Posts

Joined
Fri Jan 06, 2012 11:31 pm

Post by lemonadv » Thu May 26, 2016 8:34 pm

It's located in Bulgaria.

Newbie

Posts

Joined
Fri Apr 08, 2016 2:53 am

Post by IP_CAM » Thu May 26, 2016 10:48 pm

YSlow Score: C (78%)
could still be improved, by linking all the scripts and css files, in your header.tpl, to make 'em COOKIE-FREE, as well as
compress such files, to make 'em faster.

And when it comes to Server Performance, just get a decent hoster, NOT placing your Site, where you possibly compete, timewise, wich masses of other IP-shared URL's, on the same IP. (Just in Case, you are...)

Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by victorj » Fri May 27, 2016 4:30 am

You need to find what is causing the slow server respons.
First make sure you create a account on gtmetrix, so you can select a server nearby, next analyse site and check waterfall and see why server response is slow, is it dns slow server, bad apache config, slow sql

Dont know how far you can tweak your serve, but just google on optimizing apache and mysql and you can find loads of info on how to make your server more responsive

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by agatha65 » Fri May 27, 2016 8:07 am

Check to be sure that products counting is disabled in the menu and category (in the controller code).
Index your database.

Проверете в контролерите да е не се броят продуктите.
Индексирайте базата данни.

Suppliers Module - XML, CSV, XLS Product Feed Import and Update
Rich Snippets | Facebook Open Graph Meta Tags | WebP Images
Image


User avatar
Active Member

Posts

Joined
Fri Mar 16, 2012 10:18 am
Location - Canada, QC

Post by IP_CAM » Fri May 27, 2016 8:58 am

agatha65 wrote:Check to be sure that products counting is disabled in the menu and category (in the controller code)
Well, I would miss those numbers, really, because, beeing Customer, I hate to open empty Cat's, so, it's not worth it. And it did not stop me from getting a nice 98/93 Figure on the GTMetrix Richter-Scale, always leaving this Counting on, I just CACHED it's values, instead of letting it re-counting numbers again and again.
---
agatha65 wrote:Index your database.
Correct! And the Winner is:
Atomix INNO_DB Changer and DB Indexer Power Tool: All OC-Versions I know!
http://www.ipc.li/os/opencart-turbo-master.zip
described here:
http://forum.opencart.com/viewtopic.php ... 84#p602699
viewtopic.php?f=20&t=160694
---
Good Luck ;)
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by lemonadv » Fri May 27, 2016 3:57 pm

I already disabled the category count that was the first step maybe before half an year. Already indexed my database. The database is around 45 MB for now. Evan I enabled Memcached.

Here is the waterfall:

Image

Here is the TTFB more info:

Image

At the moment of the shots have 20 users online in front-end and around 2-3 in admin.

So I have to consider to use what Ernie suggest about Inno DB.

For now I think to use this popular full page cache:
https://github.com/budgetneon/pagecache

If someone have a suggestion about the TTFB according to the screenshots, pls let me know.

Newbie

Posts

Joined
Fri Apr 08, 2016 2:53 am

Post by IP_CAM » Sat May 28, 2016 12:40 am

just don't forget, to re-index your DB regularely, especially, after you added Mod's, adding their own 'stuff' into a DB.
And MemCache would only function, if a Server supports it! But 'use' the turbo.php, then you have it all, indexing+InnoDB.
But now better supply a link to yout Site, then, one can take a look, what's possibly still needs to be done...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by victorj » Sat May 28, 2016 2:42 am

converting database to innodb and adding index tables will help speeding up site, but not the TTFB wich in your case is a significant part off pageloead time.

you could start to optimize apache.
Unload unussed modules
if you dont use ssl then disabled mod_ssl
same for python perl ruby rackpassanger, basically everything not needed to run your website(s)

limit number of apache processes and children

optimize max clients just tweak so it will cope with highest visitor load at same time

reduce max mem for php just keep it big enough for your site to function, 64mb should good, otherwise enlarge tilll there are no out off memory errors anymore.

optimize sql, lots off info here
https://dev.mysql.com/doc/refman/5.5/en ... ation.html
there are tons off tutorials on how to tweak your server for optimum performance

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by agatha65 » Sat May 28, 2016 3:46 pm

Just checked 2 identical sites. Same hosting ( coolicehost.com ) and server, same installations, same products.
php 5.6 TTFB 0.341
php 7 TTFB 0.108

Suppliers Module - XML, CSV, XLS Product Feed Import and Update
Rich Snippets | Facebook Open Graph Meta Tags | WebP Images
Image


User avatar
Active Member

Posts

Joined
Fri Mar 16, 2012 10:18 am
Location - Canada, QC
Who is online

Users browsing this forum: Ahrefs [Bot] and 151 guests