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
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
This is pretty old now. Did you get an answer to this or resolve the issue?
Jules
In my opinion critical is the lack of indexes in tables:
I have just created non-clustered, non-unique indexes for [key] column and form saving is much faster.
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
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
This is pretty old now. Did you get an answer to this or resolve the issue?
Jules
In my opinion critical is the lack of indexes in tables:
I have just created non-clustered, non-unique indexes for [key] column and form saving is much faster.
is working on a reply...