Avoid joins in queries

SQL joins used to combine tables negatively impact performance.

Use database views instead of joins when you need to query data from multiple tables. Database views perform essentially the same function as joins, while reducing the affect on system performance.

A number of useful database views are installed with the Database Views plugin, and administrators can create new database views.