I agree on most of those, however, I disagree about using unique indexes. Uniqueness is already specified in the application layer and unique indexes (in my experience) create more problems than they solve.

Sean

Yevgeny Smirnov wrote:
I think, it's good to create the following DB indexes:

    add_index "pages", ["class_name"]
    add_index "pages", ["parent_id"]
    add_index "pages", ["slug", "parent_id"], :unique => true
    add_index "pages", ["virtual", "status_id"]

    add_index "page_parts", ["page_id", "name"], :unique => true


Yevgeny Smirnov
_______________________________________________
Radiant mailing list
Post:   Radiant@radiantcms.org
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant


_______________________________________________
Radiant mailing list
Post:   Radiant@radiantcms.org
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

Reply via email to