hum, unireg is the "global" limit, there's some ideas to change the .frm file and create a better one with less limits (drizzle database have it done), but you have limits in each engine too, index size have limits, many limits per engine exists, i think a max columns is just more one

how many columns you need? i think it's the best question, after that select a engine, if it's not a good engine, create many tables and use spider engine to group all tables (vertical partition) ?

2014-01-30 Adam Scott <adam.c.scott@gmail.com>:

I believe it's the same as in MySQL. It does depend on the engine your table is using. By default it is probably InnoDB.

For the full details about the limits:
http://www.mysqlperformanceblog.com/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/

On Thu, Jan 30, 2014 at 9:45 AM, AskMonty KB <noreply@askmonty.org> wrote:

Hello,

A new question has been asked in "MariaDB FAQ" by robpaton:
--------------------------------
Hi there,

What is the maximum number of columns a row can have in MariaDB? I can't find this info anywhere on the web.

Best regards,
Rob
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/maximum-number-of-columns/

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp

Roberto Spadim
SPAEmpresarial

Eng. Automação e Controle