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
2748
October 15, 2013 01:45PM
1269
October 15, 2013 03:47PM
1136
October 16, 2013 12:05AM
1147
October 16, 2013 09:25AM
1147
October 20, 2013 11:18AM
1211
October 20, 2013 03:24PM
Re: Procedure that select different number of columns
1149
October 20, 2013 04:09PM
1124
October 21, 2013 12:31AM
1099
October 21, 2013 09:10PM
1240
October 21, 2013 11:56PM
1103
October 22, 2013 12:08AM
1847
October 22, 2013 07:24AM
1164
October 22, 2013 09:19AM
1244
October 23, 2013 12:10PM
1111
October 23, 2013 06:23PM
2190
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.