Hello all, Firstly, I'd like to introduce myself as a new newbie here. So don't hesitate to tell me obvious reasoning that I may miss it. I've been developing some features / bugfixing in OpenChange and SOGo for a while now, so now I'm brave enough to write to this list o:).
The problem we have is the mapistore_indexing database is missing the required indexes to avoid slow queries in MySQL backend. I've added the following ones at: https://github.com/sixstone-qq/openchange/commit/61576455d21742c6bab03cd8fd7ffaca950e046e I havent' asked to be merged in upstream as we want to provide a migration tool for OpenChange to be run without external schema migration tools. Python is the language we could use to provide this schema migration. Basically, we will store a schema_version table with a row and a column to indicate the version of the schema from openchange database and we read and migrate accordingly using python-mysqldb API. The only problem we face is schema migrations in MySQL are not transactional and thus we can't rollback. Furthermore, we should change the types in mapistore_indexing for fmid (to integer) and soft_deleted (to boolean) columns. Do you have any other opinion on that? Best, -- Enrique J. Hernández - Software Architect Zentyal - Active Exchange www.zentyal.com _______________________________________________ devel mailing list [email protected] http://mailman.openchange.org/listinfo/devel
