> This is probably a silly question... but why would we rather have a > 9-tables-total database? Just that it makes mysql look less crowded, > or are there also actual benefits?
Two things on top of my head:
1) MySQL table metadata operations get sluggish when the server hits
a couple of thousands tables. All table metadata is stored in a
non-transactional engine (MyISAM) so full-table locks cannot be
avoided;
2) Control of schema creation; if you currently want to use table
compression, partitions or get complete Unicode coverage with SOGo,
you need to pre-create the schema; letting SOGo automatically create
a random number of tables defeats that.
--
Patrice Levesque
[email protected] :: +1.514.447.4918 *140 :: http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence
(http://packetfence.org)
signature.asc
Description: Digital signature
