store is slow

[wallacept]

i change htaccess and put
php_value memory_limit 64M

because i have much products.

how optimize? how faster open store?

suggestions!

p.s. i search in forum and not find solutions/suggestions!

[Shamrock]

empty your smarty cash man

[wallacept]

how Shamrock, empty smarty cash?

[Shamrock]

open ftp go tools/smarty/compile delete all files in compile catalog and you should install this good luck man

AdminTab-Cache03.zip

[wallacept]

Shamrock, this procedure is safe/security?


my presta is 1.1.0.5

[Shamrock]

im using it on my 1.1.0.5 www.dvdklubben.se works fine man

[wallacept]

ok fine.
i open ftp go tools/smarty/compile delete all files?? and index.php file?

and after?
install what?

[Shamrock]

you just delete all files in compile catalog
IMPORTANTdo not delete anything else in smarty catalog man
if you do not want to this process from ftp you can install AdminTab-Cache03.zip and empty your cash from backoffice man

[wallacept]

empty cash??
but store slow why? cash?

but empty cash no is problem?

how install AdminTab-Cache03 ?

[Shamrock]

Try this man http://www.prestashop.com/forums/viewthread/23543/developpement_et_modules/module_vider_le_cache

[wallacept]

how install this module AdminTab-Cache03?
i search this your link and not say how install!

[Shamrock]

oki i will help you man

you have 3 catalog and one file drag all files in root and over wright files then go to
http://www.yourdomain.com/install.php after this process delete install.php

then you go to backoffice tools>and tabs add new tab you have to give it a name like chash if u like
in class wright this AdminCache then you can give an icon /img/t/AdminCache.gif
then you choose where you want to put your tab my sugestion is that you put it in tools man

dose this guide good man

[wallacept]

done, but slow open store

Supprimer la compile?
or
Supprimer le cache?

or two options?

i click in "suprimer le cache" but the store are same slow!

[Radu]

presta has a veryyyyyyy slooooowwwwwwwww query in bestseller list if you have many products and/or orders

it will do no harm changing in classes/ProductSale.php from this:

       $result = Db::getInstance()->ExecuteS('
       SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, i.`id_image`, il.`legend`, ps.`quantity` AS sales, p.`ean13`, cl.`link_rewrite` AS category
       FROM `'._DB_PREFIX_.'product_sale` ps 
       LEFT JOIN `'._DB_PREFIX_.'product` p ON ps.`id_product` = p.`id_product`
       LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.intval($id_lang).')
       LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
       LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.intval($id_lang).')
       LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = '.intval($id_lang).')
       LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_product` = p.`id_product`)
       INNER JOIN `'._DB_PREFIX_.'category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
       '.($cookie->id_customer ? 'INNER JOIN `'._DB_PREFIX_.'customer_group` cg ON (cg.`id_group` = ctg.`id_group`)' : '').'
       WHERE p.`active` = 1
       AND ('.($cookie->id_customer ? 'cg.`id_customer` = '.intval($cookie->id_customer).' OR' : '').' ctg.`id_group` = 1)
       GROUP BY p.`id_product`
       ORDER BY sales DESC
       LIMIT '.intval($pageNumber * $nbProducts).', '.intval($nbProducts));

to this:

   $result = Db::getInstance()->ExecuteS('
   SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, i.`id_image`, il.`legend`, ps.`quantity` AS sales, p.`ean13`, cl.`link_rewrite` AS category
   FROM `'._DB_PREFIX_.'product_sale` ps 
   LEFT JOIN `'._DB_PREFIX_.'product` p ON ps.`id_product` = p.`id_product`
   LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.intval($id_lang).')
   LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
   LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.intval($id_lang).')
   LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = '.intval($id_lang).')
   LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_product` = p.`id_product`)
   INNER JOIN `'._DB_PREFIX_.'category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
   WHERE p.`active` = 1
   GROUP BY p.`id_product`
   ORDER BY sales DESC
   LIMIT '.intval($pageNumber * $nbProducts).', '.intval($nbProducts));    

I am using smarty cache instead of the above code however it's not trivial to present it here as you may break your store

[wallacept]

the problem persists.

no have solution? smarty have a bug? prestashop after import much products is slow?

who are problems?

[peropi101]

Hi,still in trouble here....same here man i'm using the smarty cache but still couldn't fixed it. What's my prob?




Regards,
peropi101
Placement financier

[Radu]

what's your shop?

[wallacept]

Radu store is prestashop 1.1.0.5 -> http://ccampea.com/lojacc

the people this forum is cool, but this problem not resolution.
or not? have a solution?

[Radu]

maybe the hosting is bad too, however in config/smarty.config force_compile should be false

also try disabling the bestsellers module - just for now and let me know to take another look