koskimaa

Hey everybody, I've done everything I can to optimize the speed of my store, php7+opcache, bought Jpresta's cache module, tried all the CCC options etc. But I still can't get to that magic under 200ms server response time... After reading dh42's post here: https://dh42.com/blog/prestashop-debug-profiling/ I turned on debug profiling and saw that I'm having over 1000 SQL queries, sometimes up to 1500 on a normal page (home page, category page, even product pages). You can see for yourself here: https://www.supergangu.com/japan-toys-merch (debug profiling doesn't seem to want to load on the home page every time) This seems to be way too much and the cause for why my store isn't as fast as it should be. Here is my my.cnf config: query_cache_size=512M query_cache_limit=32M query_cache_type=1 Shouldn't be any problems there. What do you think the cause of the huge amount of queries are? Is it my theme and modules that are coded poorly, or some other underlying cause? I also attached a screenshot of the debug results.

Got it. Thanks for the response!

My URL redirect module picked up that someone had tried to access the following URL's on my shop, getting a 404: I'm guessing its a bot sweeping through my site through a search engine to see if I have any vulnerable modules installed from the Warehouse theme hack. I don't use the Warehouse theme and I don't have any of the affected modules installed as far as I know of, but you can't help but worry a bit. Should I be worried?

Thanks for the response, link and your opinions! By the way, I saw you offered a 30 day trial for your module. I'll consider trying it out. I just need to figure out if I just focus on setting up a CDN before I start with a caching module, or the other way around... Also, according to you, what does your module do better than other, cheaper caching modules like this one for example?

Thanks for the input. Yes, above the fold indeed seems important. I do believe server response time and page load are equally important, not just for SEO but for user experience as well. In this day and age people are so inpatient and waiting more than 3 seconds for a page to load means they close the window and look elsewhere. That's why I think hitting that under 200ms TTFB/server response time is so crucial.

Since it's slow and outdated according to this post. Do you disagree? In that case, please explain why so we can all learn. Also, since you're the creator of the JPresta Page Cache module that I mention in my first post: Will there be any significant improvement in performance if I use your module with my store, considering I already have PHP7 and opcache active? Even though I wrote about it in my first post, I haven't actually bought and tried it yet. I'd like to know before I invest. What is the ultimate performance setup according to you? What should a shop owner do in order to reach that golden under 200ms TTFB/server response time + under 1 sec total page load. Can you have too many layers of cache? (Smarty cache + opcache + cache module + hosting provider cache + CDN cache etc. etc..)

This is the best article I've read so far on this topic: https://canonicalized.com/prestashop-speed-optimization/ but I don't understand which "File system" cache they refer to when they tell you to turn it off. The File system cache under Smarty or under "Caching"? From what I understand, using Prestashop with PHP7 and opcache gives you the fastest base performance available. Correct? Recently my host (Siteground) updated from PHP 7.0.8 to 7.0.9 which finally makes my store work with PHP7. My host also has opcache activated by default if you're using PHP7. Activating PHP7 gave me a significant performance boost, and using dh42's free opcache manager module I can confirm that opcache is indeed active. However, I still can't hit the magic "under 200ms" server response time/TTFB. I got closer, but still not there. Should I use a caching module or is there no point with opcache? Other questions where clear answers would benefit the community: - Should you always have the Smarty cache enabled in a live environment? - What is the differences between memcache and memcached?

Hi all, While building my store, I've had a hard time finding information on getting the best performance out of Prestashop. A lot of information is outdated, and there are many conflicting opinions. Below is a config that I imagine is the best you can get but I want you to correct me so that I can improve it in order for everyone to see and learn! Server config: PHP Version: 7.x.x Caching: opcache Cache module: JPresta Page Cache Prestashop Performance settings: Smarty Template compilation: Never recompile template files Cache: Yes Caching type: File System Clear cache: Clear cache everytime something has been modified CCC Smart cache for CSS: YES Smart cache for Javascript: YES Minify HTML: NO Compress inline Javascript in HTML: YES Move Javascript to the end: YES Apache optimization: YES Ciphering Algorithm: Rijndael with mcrypt.lib Caching Use cache: NO (opcache makes this alternative obsolete) CDN Should you use a CDN like Cloudflare? YES, if your customers visit your shop from several different continents in the world AND/OR if your shop is very image heavy. NO, if your target customers are all from the same country or perhaps continent. Use a server in that area and configure well and a CDN is unnecessary. Tracking/Analytics Turn OFF all Prestashop tracking, stats and analytics modules. Use external tracking like Google Analytics or Piwik. Other advanced options - "Warming up" the cache - Optimizing/cleaning the database Please post your opinions/corrections and/or other suggestions so I can update the post and we can all get a better, more up-to-date picture on how to get the ultimate Prestashop performance!

That is EXACTLY what I wanted. So cool! Thanks man, I installed the free module and it seems to work beautifully. I wish I knew this existed before i paid 40 EUR on another module that does a bunch of redirects and adds 2+ sec load time. I'm gonna consider buying the paid module if everything works out with the free one. Thanks again!

Hey guys, I was wondering if there is a way to set the default currency for all new first visitors that is different from my shop's base currency? My shop needs to use Japanese yen as the base currency since Stripe Japan can only accept Japanese yen, but since my store caters to western countries I'd like the default currency to be set to USD for all new visitors. Is there any way to achieve this WITHOUT redirects? Best regards, John P. Koskimaa

I figured it out. A module called "Auto detect language and currency" by idnovate was causing the problem. Disabling the module instantly fixed the problem. I'm going to contact the developer tomorrow to have the issue fixed. Lesson learned: Always check if modules can be the cause of a problem!!

Site: supergangu.com There is a multi-step redirect chain that significantly slows down my store page load time when a client tries to the shop. It jumps couple of times (19 times (!) according to https://varvy.com/tools/redirects/) and then finally ends up on the front page. It also seems to redirect anyone that visits the site for the first time through a suburl (Example: supergangu.com/famicom) to the root page (supergangu.com). Config: - SSL on all pages activated in Prestashop back office - Valid AlphaSSL certificate - Under SEO & URLs my setting looks like follows : Shop domain : supergangu.com SSL domain : supergangu.com Base Url : / I have tried: - Regenerating the .htaccess file - Forcing only https by adding this in my .htaccess file: RewriteCond %{HTTPS} off RewriteCond %{HTTPS_HOST} !^supergangu.com$ [NC] RewriteRule ^(.*)$ https://supergangu.com/$1 [L,R=301] - Activating HSTS by adding this in my .htaccess file: Header always set Strict-Transport-Security "max-age=63072000; includeSubdomains;" - Changing "Redirect to the canonical URL" under SEO & URLs in backoffice to "No redirection". - Disabling Apache Multiviews. - Asking my host (siteground.com), they can't see any problem with my server config Nothing of what I've tried have solved the problem! What in the name of the Prestashop god can be wrong!?! All I can think of is that some module I'm using is causing the problem, but how could I know which one? And if that's wrong too, how can I fix the problem? I need help, bad! I've been working on building my store for 4 months and want to launch as soon as the last bugs on my site are fixed. Thanks in advance to any kind soul that tries to help! / Koskimaa

Simonas, thank you for the follow-up. I'm really greatful for your help. That sounds fantastic! I may have 1000 products one day, but only a part of them will need 2-20 different attributes, depending on current stock. Is the functionality you're describing possible with a regular Prestashop install, or will I need the help of an add-on? Also, do you know of any type of tutorial or instruction video I can look at in order to learn how to set this up? Again, thank you so much for the answers, thanks to you - I'm getting more and more positive that I'll be able to make this happen.

Hi Simonas, thank you for the response! That sounds pretty good, do you know if there is a limit to how many attributes a product can have? With the method you're referring to, one attribute can't have multiple photos, right? Only one photo per attribute, I'm assuming.

Dear Prestashop community, I'm looking need to set up a storefront to sell used games and other goods from Japan to the world. Selling in Facebook groups have reached it's limit. Since I'm selling used goods, I may have several items of the same kind, but in different condition. I need your help finding a way with Prestashop, either through a vanilla install or with add-ons (I'm wiling to pay for it) to be able to show several products INSIDE a product. Let me try to explain: I may have 5 copies of Super Mario 64 but 2 of them may be yellowed cartridge-only and go for a low price, 1 may be in great condition and the other two may come complete in box, but one box is in better condition than the other. I don’t want to put up 5 different product listings and SKU's for each one, I’d rather have one product listing and then have the buyer browse all the different stock I have of that product with different photos of the condition for each item, and have the price reflecting that. The best would be if the product listing when browsing the category would say something like ¥800 ～ ¥5000 to reflect both the cheapest and most expensive options inside. If possible, I'd also like to be able to give buyers options for each product inside the product. For example. The buyer can pick a Super Nintendo in great condition instead of a scuffed or discolored one, but whichever the buyer chooses, he/she will also get the option to order a chip modification, extra controllers etc. I also need to be able to add bundles and add-on items. Example: “Get 10% off loose cartridges when you buy this console set” or “Nintendo 64 set + 3 games, pick from these 20 loose cartridges”. But I'm confident this is already built in or available through add-ons. My main concern is the multi-product picker inside the product. Super greatful for answers, I'm really eager to get started! / John K.