Fresh install prestashop 1.7.7 - very slow loading.

[alvesjc]

Hello.

 

Store with 13k products, and it's taking a very long time to load homepage.

with profiling I get the values in attachment.

The problem is with initcontent and display.

I've found a reference here about translations, but tried with all languages and all are the same.

 

How can I further debug and improve this?

 

Help appreciated.

 

[El Patron]

you may find useful information here

we would need a lot more information, i.e. screen shot of your advanced parms-->configuration

what hosting you are on, etc.

very few find golden bullet using the profiler.

 

[alvesjc]

Hi @El Patron

Thank you for your reply.

I've tried already a lot of optimizations, nothing seems to change this behaviour.

I've already striped the home page to minimal, no slider, no product list, and no big change is noticed.

I own the physical server, no shared enviroment.

The VM I created to the webserver runs with 8 cores and 64G ram, and I don't see great usage on the resources. Load is mostly under 2.

The server has SSD's for better speed also.

 

I guess you mean advanced parms -> information.

 

Info below:

Server information

Server information Linux #132-Ubuntu SMP Thu Dec 10 14:02:26 UTC 2020 x86_64

Server software version: Apache/2.4.29

PHP version: 7.2.24-0ubuntu0.18.04.7

Memory limit: 1024M

Max execution time: 3600

Upload Max File size: 128M

 

MySQL version: 5.7.32-0ubuntu0.18.04.1

MySQL server: localhost

MySQL name: dbname

MySQL user: user

Tables prefix: ps_

MySQL engine: InnoDB

MySQL driver: DbPDO

 

Store information

PrestaShop version: 1.7.7.0

Shop URL: http://cosmetics.home-bargain.com/

Shop path: <home>/cosmetics.home-bargain.com/public_html

Current theme in use: alysum

 

Mail configuration

Mail method: You are using your own SMTP parameters.

 

Your information

Your web browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36

info_outline Check your configuration

Required parameters: OK

Optional parameters: OK

 

 List of changed files

Changed/missing files have been detected.

Updated files (1)

app/Resources/translations/default/ShopThemeGlobal.xlf

 

 

 

The backoffice is also slow many of the times.

Ont thing I notice also, sometimes module changes, like disable or enable, doesn't get saved. If I refresh the page (ctrl + r) they appear in the previous state. 

Something weird is going on.

[alvesjc]

The timings shown on browser are very bad also.

 

TTFB should be less then 500ms

 

Edited January 14, 2021 by alvesjc
Wrong image (see edit history)

[El Patron]

tell me the caches if any you have implemented.  either via module or server cache....

but at end of day I'd like  to just get my hand/eye balls on the shop and hosting, pm me if you would like more hands on review.

[alvesjc]

Hi again.

For caching I only use opcache, but I've it disabled now. 

Meanwhile tried a few things.

Upgraded to 1.7.7.1 and no change on behaviour.

 

So, I moved to the default team to make sure that wasn't the theme and come to conclusion that with default team the page loads around 500ms.

So this poor performance on homepage looks like to be the Alysum theme causing it. But since I only ordered for 3 months support, can't talk with them anymore.

 

But I've other issue now with 1.7.7.1, the checkout process hangs or is very very slow after entering address. I've seen that there is an issue with very big cart's, but I'm testing with only one product.

 

Regarding the theme, with 1.6 I was able to set the theme the way I want customizing the files.

With 1.7 I can't do this easily. 

What tools do I need to edit the prestashop default theme? Can you advise on this?

I want to stop use third party themes and get back to the customized default theme.

Since I've decided to go to third party theme, all I had was problems.

 

Thanks

[markovo]

Better buy Warehouse theme. It has Elementor build in.

[alvesjc]

Well that looks good also.

 

Unfortunatly I've already invested in license for other.

 

TemplateToaster 8

But this one is offline.

You create the theme and then upload it to the shop.

 

[markovo]

On 1/20/2021 at 5:33 PM, alvesjc said:

Well that looks good also.

 

Unfortunatly I've already invested in license for other.

 

TemplateToaster 8

But this one is offline.

You create the theme and then upload it to the shop.

 

I use Warehouse theme for several shops and I can vouch that it runs great. I had a 1.6 shop once that was running on a bad theme and it was horible. So slow and somethimes couldn't even load.

[alvesjc]

Hi @markovo

 

Does that theme include AMP?

 

One thing that is holding me on abandon the current theme, is the AMP functionality.

[markovo]

I do not think so, but here are some examples what i did with this theme:

This is for 1.6 : https://www.klimaonline.bg/

This is for 1.7: https://icontrol.bg and https://fujielectric.bg

Curently I am working on another 1.7 with the latest Warehouse and I just love this theme!

It is very fast for mobile.

[nick_developer]

Hi, your website is slow on homepage and main product category or every page is slow ? 
I'm doing some optimizations on some store (with products > 100.000) and I saw that the speed problem is mostly related to the homepage and to the main category page. That's related to the high number of queries (on products tables) made on these two pages. 

Another tip: if you have the caching on filesystem on the same server, sometimes its better to use no cache at all. 
Have a try and see if with cache off you obtain better performances.

[koubin]

This happened to me when we moved a fresh installation from localhost to server. When you install, it will check all requirements and point out which are not sufficient. When you just move it, you will not find out.

In our case it was probably the 128MB PHP memory limit. When moved to server with 256MB, it started to be fast again.