MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure that select different number of columns
Posted by: Zawisza Czarny
Date: October 20, 2013 03:24PM

Your right EAV model socks, but... I can search for items with some parameters equal to "XYZ" with it, and with JSON (or other way to store information in one blob field) I can't, or it is complicated, or have terrible performacne :/ (but, on other hand, item count in each group will newer extend beyond even 300, so problems with performance are not expected...)
But on website that you point is something about "Dynamic columns" in mariaDB did someone of you use it? Can I do something similar in mysql?
Thanks for replays, I'm sure that I'll reconsider my model in some way!

Options: ReplyQuote

Written By
Re: Procedure that select different number of columns
October 20, 2013 03:24PM

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.