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 <[email protected]>: > http://dev.mysql.com/doc/refman/5.5/en/column-count-limit.html > > normally you have a serious problem if you reach that limits > because it won't scale well and the scheme is at least > questionable > > 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 <[email protected] >> <mailto:[email protected]>>: >> >> 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 <[email protected] >> <mailto:[email protected]>> 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 >> -------------------------------- > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
