Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mikkel B. Mikkelsen 52 posts 81 karma points
    Jun 18, 2013 @ 14:36
    Mikkel B. Mikkelsen
    0

    Adding indexes to the umbraco database for performance gains

    During the open space session at Codegarden this year, I attended one focused on the performance of Umbraco. At this session someone (sorry, can't remember your name!) mentioned having gained a pretty noticeable speed boost by simply adding an index to a table. As I recall it had something to do with document versions or revisions.

    Does anyone remember the specifics of this? Would be much appreciated!

  • Jeffrey Schoemaker 408 posts 2138 karma points MVP 8x c-trib
    Jun 18, 2013 @ 15:11
    Jeffrey Schoemaker
    0

    Hi Mikkel,

    you can find the notes of the open space sessions on https://docs.google.com/document/d/1v3Dqf9bvvcUP2dc4B-dTTrvyzic9npk8jvFd5W5ZUdk. If you scan long enough, you'll find that

    Database optimisation - peta poco.

    Put an index on the Property table index on version cmsPropertyData, some indexes on the table

    Package to create indexes or have it in core. But do not go crazy and index everything.

    Optimisation: VS long running queries tool, management view for unused indexes.

     

    I hope that's what you're searching for.

     

    Let me know,

     

    Jeffrey

  • Mikkel B. Mikkelsen 52 posts 81 karma points
    Jun 18, 2013 @ 15:17
    Mikkel B. Mikkelsen
    0

    Yep, that's exactly what I was looking for, thanks!

    Still, I have a feeling that there might be more places in the database where adding an index could have a positive effect on performance, so I'll leave this thread open and hopefully get some more input on the subject.

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Sep 26, 2013 @ 18:57
    Jan Skovgaard
    0

    Hi Mikkel

    Just stubmled upon this post - don't know if you also saw the stuff Mikkel Johansen shared in this post?

    http://our.umbraco.org/forum/developers/extending-umbraco/42361-This-is-a-bit-dirtybut-I-need-to-mess-with-the-database

    That's all.

    /Jan

Please Sign in or register to post replies

Write your reply to:

Draft