title: How to improve the performance of EAV Model database in mysql
body: <p>I have database with eav model tables .database is growing day by day so it is difficult to search and generating the reports. can any one suggest me the optimization steps for generating reports </p>