Support the ongoing development of Laravel.io →
bweston92
posted 8 years ago
Database Eloquent
Last updated 10 months ago.
0
luknei
replied 8 years ago

Well group by has performance issues for sure, you can solve that by using distinct + joins

Last updated 10 months ago.
0
bweston92
replied 8 years ago

@luknei Distinct isn't the same as group by. You can group by multiple fields for example.

Last updated 10 months ago.
0
jarredholman
replied 8 years ago

This is one of the things that annoys me too. It was quite surprising to see it return incorrect results.

The count() function should already be implemented this way, but it is deliberately crippled because MySQL can't optimize subqueries.

Last updated 10 months ago.
0

Sign in to participate in this thread!

LaraJobs

Your banner here too?

bweston92 bweston92 Joined 3 Feb 2014

Moderators

We'd like to thank these amazing companies for supporting us

Beyond Code
Fathom
Forge
Envoyer
LaraJobs
LoadForge
Skynet Technologies
Lightflows

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

Twitter GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2023 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise