maria-discuss team mailing list archive
Mailing list archive
Re: New Question: Maximum number of columns
nice, now one question...
what about views? how many columns?
what about spider engine with vertical partition? how many columns?
2014-01-30 Reindl Harald <h.reindl@xxxxxxxxxxxxx>:
> normally you have a serious problem if you reach that limits
> because it won't scale well and the scheme is at least
> select(*) even with most empty will create large results
> inserts/updates are much slower
> Am 30.01.2014 18:50, schrieb Roberto Spadim:
>> 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@xxxxxxxxx <mailto:adam.c.scott@xxxxxxxxx>>:
>> 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:
>> On Thu, Jan 30, 2014 at 9:45 AM, AskMonty KB <noreply@xxxxxxxxxxxx <mailto:noreply@xxxxxxxxxxxx>> wrote:
>> 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,
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
Eng. Automação e Controle