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
2990
Zawisza Czarny
October 15, 2013 01:45PM
Re: Procedure that select different number of columns
1379
Peter Brawley
October 15, 2013 03:47PM
Re: Procedure that select different number of columns
1241
Zawisza Czarny
October 16, 2013 12:05AM
Re: Procedure that select different number of columns
1251
Peter Brawley
October 16, 2013 09:25AM
Re: Procedure that select different number of columns
1252
Rick James
October 20, 2013 11:18AM
Re: Procedure that select different number of columns
1322
Zawisza Czarny
October 20, 2013 03:24PM
Re: Procedure that select different number of columns
1273
Rick James
October 20, 2013 04:09PM
Re: Procedure that select different number of columns
1228
Zawisza Czarny
October 21, 2013 12:31AM
Re: Procedure that select different number of columns
1221
Rick James
October 21, 2013 09:10PM
Re: Procedure that select different number of columns
1361
Zawisza Czarny
October 21, 2013 11:56PM
Re: Procedure that select different number of columns
1199
Rick James
October 22, 2013 12:08AM
Re: Procedure that select different number of columns
1964
Zawisza Czarny
October 22, 2013 07:24AM
Re: Procedure that select different number of columns
1281
Rick James
October 22, 2013 09:19AM
Re: Procedure that select different number of columns
1365
Zawisza Czarny
October 23, 2013 12:10PM
Re: Procedure that select different number of columns
1224
Rick James
October 23, 2013 06:23PM
Re: Procedure that select different number of columns
2296
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.