Alain Costea Posted May 14, 2013 Share Posted May 14, 2013 (edited) Hello, Can you tell me if the number of values from an attribute influence the speed of shop? I mean, if i have 3 values/ attribute for every product from 500, does it have any influence if: 1. I do for every product an attribute with 3 values, or 2. I do 1 attribute with 1500 values, and assign from there 3 values / product? ( i sell wall stickers, so, most of my product have different dimensions, and client must choose between 3 different dimensions) Prestashop 1.5.4 Thanks. Edited June 24, 2013 by Alain Costea (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted May 14, 2013 Share Posted May 14, 2013 There will be a slight slowdown if you use a lot of attributes per product, as it uses Javascript to make some calculations, and the page size gets bigger as well. If you only have about 100 combinations per product, you will not notice any difference. Link to comment Share on other sites More sharing options...
Alain Costea Posted May 14, 2013 Author Share Posted May 14, 2013 Unfortunately i have 228. But still, 10 to 12 seconds to load, seems too much... 228 : 38 colors, 3 dimensions and 2 types of surfaces... And i want to reach at least 5.000 products ... what it will happen then...? Link to comment Share on other sites More sharing options...
tomerg3 Posted May 14, 2013 Share Posted May 14, 2013 I do not believe that is the issue. Do products without attributes load quicker? What do you have the compile settings at (advanced preferences->performance) Link to comment Share on other sites More sharing options...
Alain Costea Posted May 14, 2013 Author Share Posted May 14, 2013 The problem it is not only to the products load ( and no, i don't see any differences between them). But also on the first page, on categories page, on serch products... Template cache: force compilation ( i was advised to do that for the period i upload products, and do tests) Cache: no Debug console: do not open console Combination: i cant change because is in use Features: yes Smart cache for css: use ccc for css smart cache for java script: use ccc for java script minify html: minify html after smarty compile execution compress inline java script in html: compress inline java script in html after smarty compile execution apache optimization: no ( ne internet provider advised me to move to yes after i finish with all the changes) algorithm: use rijndael with mcrypt lib use catch: no caching system: memcached Also i have two warnings 1. To use APC, you must install the APC PECL extension on your server. http://php.net/manual/en/apc.installation.php 2. To use Xcache, you must install the Xcache extension on your server. http://xcache.lighttpd.net Link to comment Share on other sites More sharing options...
tomerg3 Posted May 14, 2013 Share Posted May 14, 2013 Force compile should be set to "only when files are changed" Link to comment Share on other sites More sharing options...
Alain Costea Posted May 14, 2013 Author Share Posted May 14, 2013 I did the modification. still no change... And when click on a product from facebook shop it takes like 13-14 seconds to load. But, in facebook, it load instantly, also there are no problems with bo, control panel...Just with the shop... Link to comment Share on other sites More sharing options...
tomerg3 Posted May 14, 2013 Share Posted May 14, 2013 Try setting _PS_DEBUG_PROFILING_ to true (/config/defines.inc.php) it will display a breakdown of all the queries and how long each one took, it should help narrow down the culprit Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 (edited) After i did that, when i enter decorativ-art.ro or www.decorativ-art.ro ( my shop), it shows: Redirection automatique dans 5 secondes https://decorativ-art.ro/index.php If i enter directly https://decorativ-art.ro/index.php, still, it takes like 10 seconds to load... When i click a product, from first page, after 5-6 seconds, it shows me:Be the first to write your review ! ....and that it, no more product page...if i click on be the first... nothing happens... All that are happening in firefox. In chrom, the same, with the difference that be the first to.... is in romanian ( as it should be). In internet explorer: Internet Explorer cannot display the webpage In bo i have next messages: Load time: 482ms Good boy! That's what I call a webserver! config: 86ms constructor: 0ms init: 22ms checkAccess: 0ms setMedia: 1ms postProcess: 0ms initHeader: 6ms initContent: 361ms initFooter: 0ms display: 7ms Hook processing: 16ms / 1.7 Mb displayBackOfficeHeader: 9ms / 1.45 Mb moduleRoutes: 6ms / 0.25 Mb displayAdminListAfter: 0ms / 0 Mb displayAdminListBefore: 0ms / 0 Mb displayBackOfficeFooter: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb actionAdminControllerSetMedia: 0ms / 0 Mb displayAdminProductsListBefore: 0ms / 0 Mb displayAdminProductsListAfter: 0ms / 0 Mb Memory peak usage: 37.35 Mb config: 11.72 Mb constructor: 0 Mb init: 3.1 Mb checkAccess: 0 Mb setMedia: 0 Mb postProcess: 0 Mb initHeader: 0.51 Mb initContent: 19.14 Mb initFooter: 0.01 Mb display: 0.58 Mb DB type: DbPDO SQL Queries: 355 queries Time spent querying: 125ms Included files: 98 Size of included files: 1.69 Mb Globals (> 1 Ko only): 60 Ko HTTP_SERVER_VARS ≈ 10.9 Ko _SERVER ≈ 10.9 Ko _ENV ≈ 9.7 Ko HTTP_ENV_VARS ≈ 9.7 Ko _REQUEST ≈ 5 Ko HTTP_COOKIE_VARS ≈ 4.6 Ko _COOKIE ≈ 4.6 Ko Total cache size (in Cache class): 0.93 Mb Edited May 15, 2013 by Alain Costea (see edit history) Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 (edited) I switched back, to have acces to product page in front office... I also found this: Tables stress 100 product_shop 100 product_attribute_shop 100 product_attribute 51 product 50 specific_price_priority 50 specific_price 50 product_group_reduction_cache 9 tab 6 shop_url 5 category_lang 5 category I don't know what the stress is...if i reduce the quantities, it will be better? ( everithing at my shop os on command, so it doesn't matter the stock...) Edited May 15, 2013 by Alain Costea (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted May 15, 2013 Share Posted May 15, 2013 According to this, pages load very quickly (under a second). The slowdown is likely elsewhere, however, as your site is in maintenance mode, we can't check it out.. Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 I enabled it. http://decorativ-art.ro Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 When profiling is true, like now, product page can't be load, as you will probably see... Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 These loadings time, reffer to the BO, or to the front office, because, the bo, it is loading really fast, that is true... Link to comment Share on other sites More sharing options...
tomerg3 Posted May 15, 2013 Share Posted May 15, 2013 Looks like the culprit is your slideshow, see http://screencast.com/t/v8kDfTbu Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 I was thinking at that too, and deactiveted the slideshow, but it was no difference... Still, i replacesd the images with some under 100kb, cleaned the caches, cookies, and still no differences... I just don't know what to do anymore... Link to comment Share on other sites More sharing options...
tomerg3 Posted May 15, 2013 Share Posted May 15, 2013 Site is turned off again... I suggest you try using Page speed and see what is taking so long to load... Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 Thanks i will try page speed. It is enabled again. Link to comment Share on other sites More sharing options...
tomerg3 Posted May 15, 2013 Share Posted May 15, 2013 Something is definitely up with your site, but I do not think it is a Prestashop issue. It seems to take a while (up to 9 seconds) before it starts doing anything, I think it may be related to htaccess, or some server configuration. If you have an htaccess file, try to remove it and disable friendly URLs Try to create a phpinfo() file and send the link to it too Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 I will do a backup, and try. I also seen that it stays 9-10 seconds on index php. An i realized that my error log file has 19 mb...isn't it too much? Link to comment Share on other sites More sharing options...
tomerg3 Posted May 15, 2013 Share Posted May 15, 2013 it depends on what's in it... Link to comment Share on other sites More sharing options...
Alain Costea Posted May 15, 2013 Author Share Posted May 15, 2013 It seems i also have a roblem with magic quotes...i will try to resolve. Link to comment Share on other sites More sharing options...
Alain Costea Posted May 16, 2013 Author Share Posted May 16, 2013 I resolved the problem with magicquote, but still no difference. The erver provider think that the solution is to upgrade from 1.5.4 to 1.5.4.1, but i think that has no matter in that problem. I found that: http://gtmetrix.com/reports/decorativ-art.ro/034AkhTt I will try to resolve what they say... Link to comment Share on other sites More sharing options...
Alain Costea Posted May 17, 2013 Author Share Posted May 17, 2013 The server provider says it is a programmind issue. But I can't find a thing. It takes almost 10 seconds on index.php file...on every pany of my site: prodcut page, compare, even on simple pages like FAQ.... I can't understand... Link to comment Share on other sites More sharing options...
tomerg3 Posted May 17, 2013 Share Posted May 17, 2013 Something is definitely up with your site, but I do not think it is a Prestashop issue. It seems to take a while (up to 9 seconds) before it starts doing anything, I think it may be related to htaccess, or some server configuration. If you have an htaccess file, try to remove it and disable friendly URLs Try to create a phpinfo() file and send the link to it too Link to comment Share on other sites More sharing options...
Alain Costea Posted May 17, 2013 Author Share Posted May 17, 2013 This is my .htaccess file: <Files *.ini> Order deny,allow Deny from All </Files> SetEnv PHPRC /home/decorart/ # ~~start~~ Do not remove this comment, Prestashop will keep automatically the code outside this comment when .htaccess will be generated again # .htaccess automaticaly generated by PrestaShop e-commerce open-source solution # http://www.prestashop.com - http://www.prestashop.com/forums <IfModule mod_rewrite.c> RewriteEngine on RewriteCond %{HTTP_HOST} ^www.decorativ-art.ro$ RewriteRule . - [E=REWRITEBASE:/] RewriteRule ^api/?(.*)$ %{ENV:REWRITEBASE}webservice/dispatcher.php?url=$1 [QSA,L] # AlphaImageLoader for IE and fancybox RewriteCond %{HTTP_HOST} ^www.decorativ-art.ro$ RewriteRule ^images_ie/?([^/]+)\.(jpe?g|png|gif)$ js/jquery/plugins/fancybox/images/$1.$2 [L] RewriteCond %{HTTP_HOST} ^decorativ-art.ro$ RewriteRule . - [E=REWRITEBASE:/] RewriteRule ^api/?(.*)$ %{ENV:REWRITEBASE}webservice/dispatcher.php?url=$1 [QSA,L] # AlphaImageLoader for IE and fancybox RewriteCond %{HTTP_HOST} ^decorativ-art.ro$ RewriteRule ^images_ie/?([^/]+)\.(jpe?g|png|gif)$ js/jquery/plugins/fancybox/images/$1.$2 [L] </IfModule> #If rewrite mod isn't enabled ErrorDocument 404 /index.php?controller=404 # ~~end~~ Do not remove this comment, Prestashop will keep automatically the code outside this comment when .htaccess will be generated again Unfortunatelly I am not good at programming. Link to comment Share on other sites More sharing options...
tomerg3 Posted May 17, 2013 Share Posted May 17, 2013 I'm not sure why you posted it here, I suggested 2 things, neither of them was post your htaccess... Link to comment Share on other sites More sharing options...
Alain Costea Posted May 17, 2013 Author Share Posted May 17, 2013 You said to remove the .htacces file. You meant to deleted it? I thougt i should enter a code or something... I don't know how to create a phpini file... If i disable the friendly url, i would not have problems with optimization? Thank you. Link to comment Share on other sites More sharing options...
tomerg3 Posted May 17, 2013 Share Posted May 17, 2013 I said remove, and I meant remove You can rename it. (turn off friendly URL first). If you're now sure how to create a phpinfo() file, google it Link to comment Share on other sites More sharing options...
Alain Costea Posted May 19, 2013 Author Share Posted May 19, 2013 Hello. It seems that i didn't have turned on friendly url. because: URL rewriting (mod_rewrite) is not active on your server, or it is not possible to check your server configuration. If you want to use Friendly URLs, you must activate this mod. Link to comment Share on other sites More sharing options...
Alain Costea Posted May 19, 2013 Author Share Posted May 19, 2013 Well, another problem, although the prestashop says: Preferences SEO & URLs Set up URLs Friendly URL Yes No URL rewriting (mod_rewrite) is not active on your server, or it is not possible to check your server configuration. If you want to use Friendly URLs, you must activate this mod. my server provider says i do have url rewriting... Link to comment Share on other sites More sharing options...
Alain Costea Posted May 19, 2013 Author Share Posted May 19, 2013 Hello again. Here is the link to phpinfo: http://www.decorativ-art.ro/phpinfo.php Link to comment Share on other sites More sharing options...
Alain Costea Posted May 20, 2013 Author Share Posted May 20, 2013 Well, now, it takes 24 secs to upload. 17 just to index.php... meanwhile, i uploadet 300 new products, and for some 50 created combinations, prices... But, how could this be related by the fact that index is not loading? Link to comment Share on other sites More sharing options...
Alain Costea Posted June 24, 2013 Author Share Posted June 24, 2013 Hello, It seemed that the problem for the slowdown was that: In my theme ( not the default one), i had an option, in top menu to randomly show an image from my models. And when i had 600 models, my sites was taking almost 26 seconds, just to think... When I was taking off this option, suddenly my site is loading in 5 to 7 seconds... Thank you all! Link to comment Share on other sites More sharing options...
Recommended Posts