Yevgeny Smirnov said the following on 12/01/2008 04:25 PM:
> 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
Yes, that DOES make a difference in performance!
My designs tend to make a lot of use of page-parts (and inheritance)
(_parts_) of the sidebar, sections of a page with "go to top" or
indexes. So the page_part and parent_id bits are very effective.
(I never did figure out the 'virtual' stuff).
I suppose another set of indexes would be to the "order by' for the
<r:children:each>
Thanks!
--
You will do me the justice to remember that I have always supported the
right of every man to his opinion, however different that opinion might
be to mine. He who denies to another this right makes a slave of himself
to present opinion because he precludes himself the right of changing
it. The most formidable weapon against errors of every kind is reason. I
have never used any other, and I trust I never shall.
--Thomas Paine (The Age of Reason)
_______________________________________________
Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
