MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Procedure that select different number of columns
2517
Zawisza Czarny
October 15, 2013 01:45PM
Re: Procedure that select different number of columns
1141
Peter Brawley
October 15, 2013 03:47PM
Re: Procedure that select different number of columns
1033
Zawisza Czarny
October 16, 2013 12:05AM
Re: Procedure that select different number of columns
1040
Peter Brawley
October 16, 2013 09:25AM
Re: Procedure that select different number of columns
1037
Rick James
October 20, 2013 11:18AM
Re: Procedure that select different number of columns
1081
Zawisza Czarny
October 20, 2013 03:24PM
Re: Procedure that select different number of columns
1034
Rick James
October 20, 2013 04:09PM
Re: Procedure that select different number of columns
1026
Zawisza Czarny
October 21, 2013 12:31AM
Re: Procedure that select different number of columns
986
Rick James
October 21, 2013 09:10PM
Re: Procedure that select different number of columns
1135
Zawisza Czarny
October 21, 2013 11:56PM
Re: Procedure that select different number of columns
1005
Rick James
October 22, 2013 12:08AM
Re: Procedure that select different number of columns
1704
Zawisza Czarny
October 22, 2013 07:24AM
Re: Procedure that select different number of columns
1058
Rick James
October 22, 2013 09:19AM
Re: Procedure that select different number of columns
1135
Zawisza Czarny
October 23, 2013 12:10PM
Re: Procedure that select different number of columns
1003
Rick James
October 23, 2013 06:23PM
Re: Procedure that select different number of columns
2075
Zawisza Czarny
November 08, 2013 04:57PM


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.