Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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!
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,
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.
Just stubmled upon this post - don't know if you also saw the stuff Mikkel Johansen shared in this post?
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted