Jump to content

Prestashop performance with HUGE database response time!


Recommended Posts

Hi all,

Im posting this for hardcore and experienced Prestashop developers/users.

 

I have serious performance issue with Prestashop with:

21k products

~40 features

~2 attributes

 

The tables looks like here

post-583420-0-11017000-1427711197_thumb.jpg

 

The main problem is huge _product_feature table (210k of records sic!)

I think is feature/attribute table construction is not optimal.

 

Normal category open time is 20/30 sec with layeredblock

Disable layeredblock module help to get 10-15 sec of performance.

 

Is there any way to optimize SQL ask for this data? Any third-party search module that can handle product features more wisely?

Edited by PrestaShark (see edit history)
Link to comment
Share on other sites

Okay

I have found this thread post by PascalVG

https://www.prestashop.com/forums/topic/45000-slow-database-queries-identifying-and-fixing/page-2?do=findComment&comment=1612328

 

And this googled

https://github.com/PrestaShop/blocklayered/commit/d8628ace649a6fa2ffa105cdfc8f1f64e01246a4

 

+ found and removed DATEDIFF (SH$%^) at blocklayered.php file

 

Merged this all solutions give me some nice boost!

Edited by PrestaShark (see edit history)
  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...