midgard-schema and database update

Posted on 2008-02-11 15:21:52 EET.

I ported some minor database routines from Midgard branch-1-9 to stable branch today. It doesn't mean I ported unstable features. On the contrary , I fixed quite important issues: #193,#214 and #78.

What does it mean exactly?

Datagard creates tables and adds some additional columns and indexes but only those mandatory like sitegroup or guid. midgard-schema is improved and make all database update more clever way:

  • midgard_reflection_property is used to check if property should be indexed ( like parent property or link one )
  • Indexes are created for commonly used metadata columns

When update is performed, midgard-schema checks every single table and column if anything should be done with it:

  • Update is made as much faster as many unchanged columns you have in table ( comparing to shell's datagard )
  • During developing, you may alter table and change columns' type "on the fly".

Back

Layout Copyright © 2006 Finnish Teleservice Center Ltd Oy - Site Powered by Midgard CMS