Copied to clipboard

Flag this post as spam?

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


  • Simon Hewitt 65 posts 126 karma points
    Oct 03, 2014 @ 11:33
    Simon Hewitt
    0

    Indexing contour tables

    Hi Tim,

    Quite a few months ago Mayflymedia put up a blog post about speeding up Contour by adding non-clustered indexes on certain guids (as seen here http://www.mayflymedia.co.uk/blog/speeding-up-umbraco-contour-by-800-percent/).

    Do you have an update script available or could you specify which fields I would need to index. It would be useful to know so I don't have to index them all and then have a bigger rebuild job than necessary.

    Cheers Simon

  • Jules 213 posts 459 karma points
    Jun 22, 2015 @ 15:29
    Jules
    0

    This is pretty old now. Did you get an answer to this or resolve the issue?

    Jules

  • Wojciech Tengler 88 posts 161 karma points
    Oct 06, 2015 @ 09:52
    Wojciech Tengler
    0

    In my opinion critical is the lack of indexes in tables:

    • UFRecordDataBit
    • UFRecordDataDateTime
    • UFRecordDataInteger
    • UFRecordDataLongString
    • UFRecordDataString

    I have just created non-clustered, non-unique indexes for [key] column and form saving is much faster.

Please Sign in or register to post replies

Write your reply to:

Draft