Let me clarify, user has many organisations and organisations has many posts. The query builder generates a inner join with a select based on all organisations ids IN() statement.

Am i misusing the ORM or this is how it works? The correct SQL is to join the tables on pivot.organisation_id=posts.organisation_id which gets you the same result and runs for milliseconds, not 25 seconds like the IN statement.

Anyone???

It's depending on your data, that you need an index. Check it may be speedup yor query.

saurabhd said:

It's depending on your data, that you need an index. Check it may be speedup yor query.

Indexes are crucial to performance but i don't see what that has to do with the issue i listed. Laravel is the problem, wether i put indexes or not the resulting query from the laravel orm is abysmal.