Re: View truncates GROUP CONCATed String
Sebastian,
I think I understand it better now.
I think it´s quite safe to assume that a group by query will almost always be slower as a view than as a query, in particular when you still need to apply criteria.
That´s because MySQL is forced to evaluate the view using the temptable algorithm, see:
http://dev.mysql.com/doc/refman/5.0/en/create-view.html (a little furher than half of the page)
So, you're probably better off when you stick to your old solution.
kind regards, Roland
Subject
Written By
Posted
Re: View truncates GROUP CONCATed String
January 17, 2006 12:43PM
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.