Post by dwpmorais » Wed May 24, 2017 8:32 am

Hi.

I need help to decrease the wait time of my site.

Https://www.oreidomdf.com.br/

I have more than 100 categories and 900 products.
Using opencart 2.3.0.2 with Fastor theme.

But is very slow. (5 or more seconds - Time to First Byte )
Gtmatrix results
Image


What could I do to make my site better?

Thank you all

Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by IP_CAM » Wed May 24, 2017 9:41 am

just read the first TAB of GTMetrix Results... :D
it's all there, in detailled form ! ;)
Ernie
PS: cannot add image in here, too large, get it by right mouse click show graphic!
And don't ask me anything, I don't know your version and theme..., sorry.

My Github OC Site: https://github.com/IP-CAM
5'600 + 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

User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by artcore » Wed May 24, 2017 4:41 pm

In my humble opinion one should not use cache to hide server load and or coding issues. When cache expires you will have the same slow response. And what about ajax and other dynamic calls? eg add to cart, payment provider callback...

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by dwpmorais » Wed May 24, 2017 7:42 pm

Hi.

I believe the problem is not the photos. Why the problem was the same before adding images to the products.
Can not be database? I've seen similar problems but it was opencart 1.5

Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by sculptex » Thu May 25, 2017 4:33 pm

Even though that theme doesn't seem to show category product count, is that option enabled in store settings?
You could try my advice from this other thread linked below and post result log file here, we will soon see if it is database problem

viewtopic.php?f=190&t=184033#p673643

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by dwpmorais » Thu May 25, 2017 9:16 pm

Sculptex option (show category product count) is disabled.

I installed the file you requested. But did not create a log file.
Opencart 2.3 does not have the folder system/logs

The logs go to system/storage/logs.

I changed the file category.php

Replace:
$ Product_total = $ this-> model_catalog_product-> getTotalProducts ($ filter_data);

With:

If ($ this-> config-> get ('config_product_count')) {

$ Product_total = $ this-> model_catalog_product-> getTotalProducts ($ filter_data);
}
  Else {
$ Product_total = 0;
}

The TTFB was for 1-2 secs.
Image

Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by sculptex » Fri May 26, 2017 6:27 am

quite right, I didn't test it with 2.3, here's another version that should work with all 2.x and the log folder will be the system log folder which as you say in 2.3 is system/storage/logs

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by dwpmorais » Fri May 26, 2017 8:07 am

After install.

Notice: Trying to get property of non-object in admin/controller/extension/modification.php on line 146

Did not create log file.

Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by sculptex » Fri May 26, 2017 3:12 pm

Its a vqmod did you try to install it as an ocmod?

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by dwpmorais » Fri May 26, 2017 8:59 pm

Now.
I changed to folder -> vqmod / xml ;D

Results:
https://www.dropbox.com/s/0hl8433oar8pr ... 4.txt?dl=0
https://www.dropbox.com/s/icnr3627w6c4o ... 5.txt?dl=0

300kb each file, good thing is not. lol

Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by IP_CAM » Sat May 27, 2017 12:52 am

well, as I meant in my Posting, you're jumping around on the wrong Horse,
by example, instead of caching Category Product Counting, you tried to remove it,
and so killed the Pagination Display as well. :'( .
It's just not gonny work, this way, as planned..., good Luck ::)
Image

My Github OC Site: https://github.com/IP-CAM
5'600 + 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 sculptex » Sat May 27, 2017 1:40 am

Every other line is
SELECT * FROM oc_setting WHERE `code` = 'timezone'
Is that part of that theme? that is not normal. Thats probably over half the time taken!
Search for that query (not the whole string as the oc_ is variable) and see why its doing that.
Its like its attached to the db engine to perform that before every other query??

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by dwpmorais » Sat May 27, 2017 3:50 am

SELECT * FROM oc_setting WHERE `code` = 'time zone'

It was not the theme It was an extension. It was removed.

Here is a new log.
Look.
https://www.dropbox.com/s/f4458sy3n2mkz ... 9.txt?dl=0

Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by sculptex » Sat May 27, 2017 5:53 am

Thats saved over a second on sql queries. There is still loads of duplication though, probably due to the theme, I can't tell without looking.
An sql cache would help a bit, I have developed one myself, but it would not fix a badly written theme, just reduce the 0.9 seconds each page is spending on SQL queries.

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by dwpmorais » Sat May 27, 2017 8:21 am

You're right.

I tested with default theme.
Image

with Fastor.
Image

I still tested the original theme. Ridiculous :-[

Image

Attachments

3.jpg

3.jpg (149.17 KiB) Viewed 2793 times

2.jpg

2.jpg (152.58 KiB) Viewed 2793 times

1.jpg

1.jpg (149.29 KiB) Viewed 2793 times


Newbie

Posts

Joined
Wed May 24, 2017 8:06 am

Post by sculptex » Sat May 27, 2017 4:03 pm

Wow, thats shocking! I just tried it on google pagespeed insights - it scored 0/100!!!
That is disgusting
https://developers.google.com/speed/pag ... tab=mobile
Although a few things can be done to improve, I think the theme is the problem here and you will never get good speed using it.

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK
Who is online

Users browsing this forum: No registered users and 35 guests