Re: Procedure that select different number of columns
Posted by:
Rick James
Date: October 20, 2013 04:09PM
> "Dynamic columns" in mariaDB did someone of you use it? Can I do something similar in mysql?
MariaDB is a compatible 'replacement' for MySQL. Dynamic Columns is one of several added features you get on top of standard MySQL.
> item count in each group will newer extend beyond even 300, so problems with performance are not expected
If you fetch only 300 rows, almost any solution (brute force or otherwise) will have "good enough" performance. So, it might be best to focus on simplicity of the implementation, not on performance.
Subject
Views
Written By
Posted
2744
October 15, 2013 01:45PM
1265
October 15, 2013 03:47PM
1133
October 16, 2013 12:05AM
1143
October 16, 2013 09:25AM
1142
October 20, 2013 11:18AM
1206
October 20, 2013 03:24PM
Re: Procedure that select different number of columns
1144
October 20, 2013 04:09PM
1121
October 21, 2013 12:31AM
1093
October 21, 2013 09:10PM
1236
October 21, 2013 11:56PM
1098
October 22, 2013 12:08AM
1843
October 22, 2013 07:24AM
1160
October 22, 2013 09:19AM
1241
October 23, 2013 12:10PM
1106
October 23, 2013 06:23PM
2188
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.