Quick Tip: Adding properties to Members results in a timeout

A quick tip/note on one possible solution for combating timeouts when adding properties to Members

There you are, working away on an Umbraco site with a large member base, and you need to add a new property. So off you go and add it to the member type... you click save.......

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.

Not the message you want to see when saving a property on a member type, or performing a uSync import that does the same action!

Well, that is exactly what happened to me sigh.

So, after some googling, I was fortunate to come across this little twitter thread:

And this helpful response:

So that is exactly what I did, I extended the timeout on my connection string temporarily and boom member property added!

Note This blog entry is a quick tip, and over time may become outdated. There may also be better alternative solutions to the problem.