Skip to main content
5 events
when toggle format what by license comment
May 4, 2020 at 8:12 comment added Lennart - Slava Ukraini @user208176, the problem with EAV is that the complexity grows very fast when adding more attributes to the equation. N attributes will require N-1 joins and the table itself usually grows fast since everything is lumped into one table. If you want control over resource usage like CPU, disk etc, you should probably consider limiting the number of attributes that can be used by a query.
May 4, 2020 at 7:00 comment added user208176 Thanks its exactly what i am looking for, is this good approach for ecommerce site filtering? i am doing tests with your given code for each request to show 20 results it takes 0.1 second, should i spend more cpu when scaling the application?
May 4, 2020 at 6:57 vote accept user208176
May 4, 2020 at 3:52 history edited danblack CC BY-SA 4.0
added 9 characters in body
May 4, 2020 at 1:46 history answered danblack CC BY-SA 4.0