Desperate! Speed Issues Again and Again

[InnovatecInc]

Hi 

 

I love Prestashop but for the life of me I can't understand why, when out of the box, using the default theme, PS is occasionally very slow!

 

I have used it on three different servers now and the same issue - it fuctions fast 60% of the time and incredibly slow the rest of the time - load times of 10-20-30 seconds.

 

I actually run some extra PHP code on the side occasionally - in a subfolder - to update product prices etc and sometimes my own code runs slowly.

 

So my gut feeling is that it is server or database issues - but not sure.

 

Any ideas cos my bosses want answers NOW and I am at a loss and very fustrated.

 

Steve 

[El Patron]

Hi Steve,

 

As you can guess nobody can answer your question without more information, including yourself.

 

enable ps profiling config/defines.inc.php change this to true

 

define('_PS_DEBUG_PROFILING_', false);

 

then visit page(s) and when it's slow check the report at bottom of page.

 

note: turn off when done as all visitors will get this report.

[InnovatecInc]

Thank El.

 

Our page is modernfurniture.com.au

 

We are on a shared server. We are using basic CloudFlare however this issue persist regard of whether I use CF or not.

 

I just attempted to load a page and it took about 15 seconds, but sometimes this can be longer. 

 

Andrew, at our host server, ran some tests and it gave the site 75/100 - there is room for optimization but we are quite good. We rank about this on

Google Page Speed too. Regardless, this should not affect load times of 15-20 even 30 seconds, surely.

 

Here is a link to the performance data - looks sorta ok - except table stress on product attributes - but these tables are empty and not used - so this might be the bottleneck.

 

https://modernfurniture.com.au/profile.html

 

Hope you can help.

 

Cheers

Steve

Edited June 18, 2015 by InnovatecInc (see edit history)

[tuk66]

I did a test (6:50 GMT).

 

It took 3.25s to load HTML of the home page and the total 9.2s to load all elements. It looks like your shared hosting is overloaded sometimes. You also should combine all JavaScript files (CCC) to one. That HTML loading time is quite normal at the moment.

[InnovatecInc]

Thanks Tuk

 

yeah the site is generally good - it is when we get long loading times that is the issue.

 

I have CCC enabled. And using Cloudflare too.

 

A question:

 

is it not possible to run a PS site with a couple of hundred products on a shared server? Does this sort of data

need to run on a dedicated server to achieve consistent loading speeds?

 

Steve

Edited June 18, 2015 by InnovatecInc (see edit history)

[PhilCorleone]

Interesting, your issue crosses my "bigger" issue which I have been working on since the morning.

 

I won't get too deep and get you loss, easy language promise.

 

From the experiences I have collected over the years, these are my advices:

 

1. Presta has too much JavaScript redundancies, meaning that it will execute the code more than once where it is needed to be executed only once. This what causes slow back office for example. 

2. Follow Nemo's post to enhance back office speed at Link

3. If you top it even with this! Your BO will be a jet Link

4. You literally need to bail on those shared hosting guys and move on to a better solution while preserving the same budget.

5. Conduct a test first to see why your presta is slow. From many test, I would suggest you get the IP of your website then hit Bing and type in the search box: IP:123.123.123.123 which is your website's IP. It will show you all the other websites on your server. From your perspective, you can determine if these websites get a lot of visitors in the morning which consumes the server's ram which also affect your website. You see what I mean? 

6. Focus on compression and caching, by going back to BO > Performance and enable all CCC (Compress, Cache, Combine).

7. Increase your caching settings from server side, that would be by tuning PHP.ini file, using nginx instead of Apache etc. 

 

It is just to broad to judge everything now, but at least these are initial thoughts. Let me do some testing on your server and i'll be back.

[PhilCorleone]

Your webserver looks legit, nothing is wrong with it, your provider is doing his best.

 

Ummmmm, from my personal opinion on your case, and not to complicate things on ya. You need a module like this:

 

https://www.xtendify.com/en/modules/prestashop/front-office-features/111-express-cache-speed-up-your-prestashop

 

Be free to ask about anything.

[InnovatecInc]

Thanks Phil for you insights.

 

The A record for Modern Furniture is 175.45.134.80 and searching this IP returned a lot of websites. I have actually done this previously to see who shares our server. The list is extensive. And to see what traffic each is getting at the time our site slows is obviously impossible to determine from my end. 

 

But any insights you might find that would be great.

 

Have u looked at the performance report l link I posted earlier - does it look relatively normal - and not from a page that took approcx 20 seconds to load?

 

Cheers

Steve

[InnovatecInc]

Hi Phil

 

doesn't CloudFlare essentially serve the same purpose as the module you suggest?

 

Are you saying that, given the number of people sharing the server, that unless we move to a dedicated server periodic slow page loads are inevitable?

 

Steve

[PhilCorleone]

Everything looks normal, your provider uses the best of the best of software and configs to keep the server running.

 

By the way, sorry never recalled the CloudFlare thing. But if the way prestashop was built is slow, do not expect cloudflare to go into codes and enhance things up for ya. Yeah it caches and serves the caches but as long as your website is alive on the other end which internally is slow.

 

The paid components you see above are actually for guys who wrote them to dive into the script's code and speed up things internally rather than externally. 

 

I do not want you or any other member to get me wrong about prestashop. Presta is great but I can see that the developers are more geared toward adding features for now rather than tuning. Once they have a complete implemented list of feature, then we can see major speed/performance optimizations.

 

The guys who write modules to speed Presta are taking the time to tune not to build, you see?

 

Last but not least, your server and reports are ok. It is all pinned down to Presta for now. I have looked up the prices for your provider and they look like spare change. If you consider moving to a new host tomorrow while preserving the budget, consider droplets from digitalocean.com, but for the meantime and based on your needs, I do not see the need to move.

[InnovatecInc]

Thanks for all your help Phil.

 

It is very annoying to have a slow site as this impacts on sales and SEO etc etc - which should be the core of PS dev - to develop fast core code - then add features. Just my perspective.

 

I have contacted PS directly about the issue and hoping to get some feedback.

 

Will definitely look into that module if it can help.

 

Steve

[PhilCorleone]

I'm speeding up two Prestas at the moment and you crossed my mind. In a nutshell, here is what you gonna have to do:

 

http://gtmetrix.com/reports/modernfurniture.com.au/QgVaxWWy

[vbatra]

I don't know which host you are on but my host provides me MemCache which really has increased speed a lot.

 

http://gtmetrix.com/reports/www.geekskart.com/UP9hYHsw

[akashs]

any one can resolve my problem my database is one server and my data is other server so site speed is slow so any solution to run fast