MySQL Forums
Forum List  »  General

Re: View truncates GROUP CONCATed String
Posted by: Roland Bouman
Date: January 17, 2006 12:43PM

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

Options: ReplyQuote


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.