xiverisx Posted October 29, 2012 Share Posted October 29, 2012 Hi, my company is often using Prestashop for our clients eshops websites and now we really need some help from others developers to deal with this problem. The website now we are building is using prestashop version 1.5.0.17. Server data: PHP 5.3.6 / MySQL 5.0.67 The problem is sql performance issue when you are going to a category page which has now ~1700 products and SQL query which is generated in a Category.php class function getProducts() is performed from 5s and more. First we would want to know the reasons why it is so slow and what actions we could make to make it a lot faster? Link to comment Share on other sites More sharing options...
xiverisx Posted October 30, 2012 Author Share Posted October 30, 2012 Quite sad that i hadn't recieved any replies, but the reason for mysql executing so long one SQL was a line where selected products where beeing ordered by orderprice or name. So made some small hack and now everything works in category with a lot of products quite fast, but i didn't know if it's a bug and why that SQL was so slow. Link to comment Share on other sites More sharing options...
BillyHardcore Posted November 16, 2012 Share Posted November 16, 2012 Interesting, Iveris, could you care to elaborate on what exactly you did? I have 1500 products, and seeing slow load times as well. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts