I would like to optimize Views as they cause most of my performance bottlenecks.
The MySQL slowlog shows not only Views related query times > 5s but, what is more scary, selects with over 10 LEFT JOINs. I have already manually removed some columns from views. It was over 14 LEFT JOINs before...
Are there any solutions (without writing custom module queries) to eliminate or limit LEFT JOINs in Views select queries ?
I found there is the Shadow contrib module available. Is it ready for production website?