On 5/19/2016 4:12 PM, Patrice Levesque ([email protected]) wrote:
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.
It'd be cool to run a performance benchmark, SOGo Before and After the
SQL upgrade to 9 tables total! I suspect the speed gains will score
very impressively!
--
[email protected]
https://inverse.ca/sogo/lists
