smithy01 Posted September 29, 2014 Share Posted September 29, 2014 Hello, could anyone please help me with performance tweaking of PS v 1.5 - we have couple of products with multiple combinations - approx 1300 - and it is known to me that this particular feature causes PS to load product listing slowly (when using 1000-3000comb´s)... I discovered that product listing loads just fine (3-6seconds) when listing products that have least combination used... I have two categories with approx 1300 combinations and loading them takes 30 seconds at peaks... - my understanding is - that PS loads these combinations also in the product listing on the background - which causes slow loading due to complicated SQL queries? - Would loading combinations be sufficient only when a detail of a product is loaded... ? My question is: is there a way to lightweight the SQL query for product listing in order to speed up the page? Please see this one as an example: http://devel.nexdesi...roller=category Other pages load within 5 secs due to low ammount of combinations used. Any help would be greatly appreciated. Thank you in advance! BR, Daniel Link to comment Share on other sites More sharing options...
JPresta.com Posted September 30, 2014 Share Posted September 30, 2014 First enable profiling to determine where your site is slow: http://www.webhostinghub.com/help/learn/prestashop-15-tutorials/enable-debug-profiler and post the result here. Link to comment Share on other sites More sharing options...
smithy01 Posted October 1, 2014 Author Share Posted October 1, 2014 Hello and thank you for replying, I have enabled the profiling by editing to: define('_PS_DEBUG_PROFILING_', true); Thank you! Daniel Link to comment Share on other sites More sharing options...
smithy01 Posted October 1, 2014 Author Share Posted October 1, 2014 After enabling the profiling I can see that at this time PS loads all product attributes, - if only this could be omitted from the SQL query... :-/ Link to comment Share on other sites More sharing options...
JPresta.com Posted October 1, 2014 Share Posted October 1, 2014 Can you show us the dump? Link to comment Share on other sites More sharing options...
smithy01 Posted October 1, 2014 Author Share Posted October 1, 2014 Excuse me, could you please give me guidance on how to do this? Thank you. Link to comment Share on other sites More sharing options...
smithy01 Posted October 1, 2014 Author Share Posted October 1, 2014 You mean exporting complete DB file? Link to comment Share on other sites More sharing options...
JPresta.com Posted October 1, 2014 Share Posted October 1, 2014 You mean exporting complete DB file? no no, when you enable profiling there lot of informations at the bottom of your store, can you show it to us? Link to comment Share on other sites More sharing options...
smithy01 Posted October 1, 2014 Author Share Posted October 1, 2014 Well this is already enabled - please see the THIS LINK. Thank you! Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 1, 2014 Share Posted October 1, 2014 it will help if you CCC .js and .css files, via back office. also to improve page render, espeically since you are 1.5, see this module: http://www.prestashop.com/forums/topic/314461-module-javapro-prestashop-performance-significantly-speed-up-your-shop-pages-defer-javascript/ Link to comment Share on other sites More sharing options...
JPresta.com Posted October 1, 2014 Share Posted October 1, 2014 Whouaw, this SQL query is very slow! It may have been improved in 1.6 but I'm not sure. Other big issue in your product page: you display small images 50x62 but there are actually in big format 900x600! It takes long time to download. The best would be to use a sprite here. If you don't want to migrate you can install an HTML cache module like PageCache (developped by me but some others exist). Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 1, 2014 Share Posted October 1, 2014 also I don't think the redirect you are using to categories is helping much. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 1, 2014 Share Posted October 1, 2014 also for attributes, bo-->advanced parms-->performance scroll to bottom enable file cache depth '1'. I've played with this, the only issue I cam across is confusion at module install/uninstall. Link to comment Share on other sites More sharing options...
smithy01 Posted October 2, 2014 Author Share Posted October 2, 2014 Thank you guys for helpful tips! I will give it a chance and will get back to you with results! :-) I will post back here in case I have any difficulties :-) Thank you very much once again! Daniel Link to comment Share on other sites More sharing options...
smithy01 Posted October 2, 2014 Author Share Posted October 2, 2014 Hi, I have enabled CCC, I also enabled Cache as following: also for attributes, bo-->advanced parms-->performance scroll to bottom enable file cache depth '1'. and now I am re-creating sprites for product combinations... Though the page loading time is still incredibly slow for this particular category. I am quite desperate on how to solve this riddle... :-( @El Patron - could you please help me with - "also I don't think the redirect you are using to categories is helping much"? Thank you. Daniel Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 2, 2014 Share Posted October 2, 2014 http://screencast.com/t/B1OGbpXSe If I enter your shop, i.e. index.php it is redirecting. This may just be how your set up your testing environment, but it can 'really' slow things down. also, turn off prestashop debug mode, that is why I see this message on redirect, only turn on when debugging. You mentioned the things you did but did not remark if an improvement. and if you are working on sprites, then you are wasting time...you should focus on what improves 'above the fold' page render. remember, reporting tools, must appear to be relevant, so they report some really dumb stuff...my two cents. tip: if possible, develop in subdomain rather than having redirects from one domain to another... Link to comment Share on other sites More sharing options...
smithy01 Posted October 2, 2014 Author Share Posted October 2, 2014 Thank you El Patron :-) I am definately trying to follow your remarks :-)) I disabled profiling, initial redir and debug mode :-) Could you please try now? Daniel Link to comment Share on other sites More sharing options...
smithy01 Posted October 2, 2014 Author Share Posted October 2, 2014 (edited) One more point to mention here is that I only need "flat" level combinations, - this means that for each version there always is the same ammount of variations and same variations... so if I only could simplify the sql query responsible for listing products in product_list.tpl... but this is just an abstract idea and I am not sure if that is possible.. :-/ Edited October 2, 2014 by smithy01 (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 2, 2014 Share Posted October 2, 2014 One more point to mention here is that I only need "flat" level combinations, - this means that for each version there always is the same ammount of variations and same variations... so if I only could simplify the sql query responsible for listing products in product_list.tpl... but this is just an abstract idea and I am not sure if that is possible.. :-/ good way to destroy your shop. I did not see what ps version you are using. also: I still don't see CCC of .css and .js files. Link to comment Share on other sites More sharing options...
smithy01 Posted October 2, 2014 Author Share Posted October 2, 2014 Uhm... ok abandoning the sql editing idea then... I use the following version: PrestaShop™ 1.5.4.0 Regarding the CCC: in the BO I have these settings enabled: Smart cache for CSS: Use CCC for CSSSmart cache for JavaScriptUse CCC for JavaScript Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 2, 2014 Share Posted October 2, 2014 ave maria pues (omg in ColOmiban Spanish) 1.5.4? is this new shop, or you just been developing new shop for like a year..jajaja 1.5 is not 'known' for it great performance. you biggest issue with 1.5, is java top. period... can you move this test shop to a subdomain? then you not need redirects while testing... Link to comment Share on other sites More sharing options...
smithy01 Posted October 2, 2014 Author Share Posted October 2, 2014 El Patron, Please excuse me. I still lack the knowledge regarding the PS. I am a newbie and this is the point. So I am going to upgrade the shop version. Could you please give me advice to what version should I upgrade? Regarding the subdomain - I will move the whole shop to the dedicated domain. Daniel Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted October 2, 2014 Share Posted October 2, 2014 El Patron, Please excuse me. I still lack the knowledge regarding the PS. I am a newbie and this is the point. So I am going to upgrade the shop version. Could you please give me advice to what version should I upgrade? Regarding the subdomain - I will move the whole shop to the dedicated domain. Daniel ...I'm not saying you should upgrade, I was just surprised that you are developing a shop with 1.5.4. You may have very good reason to use that version, 1.5 is still a good version. I still use 'several' 1.4.shops. as for upgrading, be very careful there, create another test shop to practice upgrades. sorry, I do not want to confuse you from original topic. Link to comment Share on other sites More sharing options...
smithy01 Posted October 3, 2014 Author Share Posted October 3, 2014 I think I should update - because from what you have stated previously - 1.5.4.0 is known to have performance problems... This is actually what I am doing right now... I will post about the results... Link to comment Share on other sites More sharing options...
smithy01 Posted October 10, 2014 Author Share Posted October 10, 2014 Hello again. Finally we solved slow time of loading the PS category listing by reducing the SQL query! The original loading time of the mentioned category was 50s now we load the page in 0.8s. We ommitted 3 tables from DB which in this case were useless and caused the trouble - excessive loading time. Anyway thank you for your thoughts! BR, Daniel. 1 Link to comment Share on other sites More sharing options...
Pluncker Posted December 4, 2014 Share Posted December 4, 2014 Hi Smithy, could you please provide your solution? I am running into the same problem. With 1.4.4.1 displaying a product with > 1000 combinations takes about 0.5s, with 1.6.0.9 more than 40s!!! Thank you! Link to comment Share on other sites More sharing options...
moy2010 Posted December 4, 2014 Share Posted December 4, 2014 Try to update to Prestashop 1.6.0.11, there are some improvements to the combinations system. 1 Link to comment Share on other sites More sharing options...
Pluncker Posted December 5, 2014 Share Posted December 5, 2014 @moy2010: Thank you, I will prove it with 1.6.0.11. In between, I turned off cache in BO (filesystem cache) and now the product page loads in 4s (which is about a tenth of the original loading time, but it is still slow). I can't use Memcached or APC. System profiling shows 1966 SQL queries (product with 1728 combinations). There is literaly one single sql query for each combination, generated in classes/SpecificPrice.php. Link to comment Share on other sites More sharing options...
daniel2211 Posted December 6, 2014 Share Posted December 6, 2014 I am using prestashop 1.5 my advice is to by module express cashe second thing is to bay JavaPro Performance next thin is clear your database with database optimatisation. Now dont use cashe option becouse you already have cashe module for better use of JAVA module test all options for best performance. I dont have to much products and my website is well optimised but with this 2 modules i made great results. Youcan check my website speed result also there is more space to improwe when i use css sprites,pictures are reduced.I find that mz cashe module when cashe is enabled slow my prestashop,disable cashe when you do this. In attachment you have performances,they are on serbian but you can figure out what is what. I hope that this will help someone My website for test 2 Link to comment Share on other sites More sharing options...
rotamaxima Posted December 26, 2014 Share Posted December 26, 2014 Hello smithy01, I'm having the same problem like you. Please, could you tell us witch tables and files were changed to solve this problem ? Link to comment Share on other sites More sharing options...
andresams Posted June 26, 2017 Share Posted June 26, 2017 (edited) I am having this exact same problem with a store where all products have combinations. This same query is performing very slow, taking up to 10 seconds to execute. It is probably not necessary to select the combinations only to display a list of products, so I will try to simplify this query too. It is happening on Prestashop 1.7, they should have fixed it years ago. Edited July 17, 2017 by andresams (see edit history) Link to comment Share on other sites More sharing options...
franky.martin Posted March 25, 2019 Share Posted March 25, 2019 (edited) Same problem in PS 1.7.4.4. Impossibile to edit stock in product with combinations, very slow and only save the first quantity. Edited March 25, 2019 by franky.martin (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted March 25, 2019 Share Posted March 25, 2019 upgrade hosting....or hire a professional to diagnose.... also this very old post, for best community support 1) create your own post, don't use someone elses and 2) stop being lazy and posting 'I have same problem'.....3) see 1) Link to comment Share on other sites More sharing options...
franky.martin Posted March 26, 2019 Share Posted March 26, 2019 (edited) Great answer El Patron 😞 Nobody try to solve the problem...when I speak with my hosting company they say me that the problem is Prestashop, and when I speak with Prestashop they say the problem is my hosting. jajajajaja joojojoojj PD: I am not lazy, I am boring of Prestashop problems. If I will create a new post I am sure I will get "please not duplicate post" Edited March 26, 2019 by franky.martin (see edit history) 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now