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: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
_______________________________________________
Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
