Hello Alberto Federico Turelli
On 2012-06-28 14:48, Alberto Federico Turelli wrote: > Hi all, > I am also trying to get the big picture about mysql tables' > relationships and about the way SOGo stores data. > Three "default" tables for each user means a lot of tables in > environments like - say - 500 users: There is no problem in having lots of tables. We have 14000+ users by the way. > has anyone already tried to > "migrate" the database structure to three single tables, with an extra > field to match the current user? No, I didn't, as this has some drawbacks. * restoring for one user is more difficult. * Locking is more expensive especially when you have a lot of concurrent users writing data. > Is there any configuration option to keep the data in a more-or-less > fixed number of tables? > No, there is none. What problem do you have with this approach? Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
