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!
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.
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!
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
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.
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
is working on a reply...