Re: Make optimized LEFT JOIN with GROUP BY
I tried adding recepti.ID to the multi index, but doesn't help.
But as sson as I use GROUP BY recepti.datum instead of recepti.ID it uses where and the query is 100x faster... I don't understand the logic but... I can also use group by recepti.datum, but if 2 recipes would have same datetime one will not show in the list so I prefer the ID.
Is there any way to say mysql I want only one data from table pictures? Then I wouldn't need to use group by...
It seems such a basic problem for me...
Edited 2 time(s). Last edit at 05/03/2006 10:30AM by Jerry Potokar.
Subject
Views
Written By
Posted
12701
May 03, 2006 08:30AM
5353
May 03, 2006 09:11AM
4258
May 03, 2006 09:20AM
Re: Make optimized LEFT JOIN with GROUP BY
3776
May 03, 2006 09:21AM
6046
May 03, 2006 01:19PM
4169
May 03, 2006 02:38PM
2645
May 03, 2006 02:43PM
3692
May 03, 2006 03:35PM
3632
May 03, 2006 12:58PM
2500
May 03, 2006 01:17PM
2453
May 03, 2006 01:23PM
2360
May 03, 2006 04:03PM
2229
May 03, 2006 04:17PM
4362
May 03, 2006 04:29PM
2496
May 03, 2006 05:09PM
2571
May 03, 2006 05:45PM
2594
May 03, 2006 06:41PM
2387
May 04, 2006 06:05AM
3919
May 04, 2006 08:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.