smithy01
-
Posts
14 -
Joined
-
Last visited
smithy01's Achievements
-
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.- 33 replies
-
- 1
-
-
- product combination generator
- slow load
- (and 2 more)
-
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...
-
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
-
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 CSS Smart cache for JavaScript Use CCC for JavaScript
-
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.. :-/
-
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
-
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
-
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
-
Well this is already enabled - please see the THIS LINK. Thank you!
-
You mean exporting complete DB file?
-
Excuse me, could you please give me guidance on how to do this? Thank you.
-
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... :-/
-
Hello and thank you for replying, I have enabled the profiling by editing to: define('_PS_DEBUG_PROFILING_', true); Thank you! Daniel
-
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