How to optimize the DB queries?

[timothepearce]

Regarding the architecture of the quasar_projections table, it seems possible to create some kind of composite index to optimize the speed.

[timothepearce]

Does anyone have the skills to help me on that?

[tommica]

Isn't it as simple as having $table->index(['projectable_type', 'projectable_id']); ?