LOCALHOST Access too slow with 5000 products in DataBase, why ?

[verdig]

Why in LOCALHOST the access to Webpages, Database is too slow (30sec) when you have about 5,000 products ?
Any parameters to tune ?
Is PrestaShop ready to accept 5,000 products ?

somebody to help me ?

[MahmutGulerce]

Hi
No prestashop isnt ready..
I have 12.000+ produck and my page loads are 45 sec.. But also if you have just e few poducts, prestashop is slow too. At least its 5 sec late
It isnt about only mysql. The main problem is smarty. Smarty is the worst framework if you it for a use cache-disable project. At any page load i can see whats happening via SSH. For ex my categories block calls 986 row from ps_category and 986 row from ps_category_lang etc. i think it must be able to cache. Medium categories change frequens is ones e week. But completely same rows, queries 50.000 times in a day. The products and other blocks too.
Sory for my english.

[Baba Uka]

Looks like I have similar problem
Is there a quick solution for this?

[Baba Uka]

By the way, how to see the time spent with ssh?

[MahmutGulerce]

@Baba Uka
I have single site on a vps. So i can see the performance for one prestashop. apache mysqld httpd percent of CPU,ram, etc usage. You can see spending time by using some browser extentions, or a litle php script like

<?php $starttime=date("isu"); //u is microsecond only php5.2+


....
prestashop
content
....



$finishtime = date("isu"); // you can print or log
?>


Command
# Top