WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
Realistically: Not every kind of data fits well into the WordPress meta model. Sometimes, you’d be better off making a custom set of tables for your data. If you have to query against 7 different meta values and a taxonomy, then perhaps a custom post type is not the best way to store your data. … Read more