Timeout on Stored Procedure that takes a little over a minute to run

[acarlso1]

I've got a Stored Procedure but it can sometimes take a minute or a little more to complete. I can't seem to find a way in DAL2 to extended the timeout which seems to be locked at 30sec. I've tried setting the SqlCommandTimeOut in the web.config but didn't seem to change anything.

using (IDataContext ctx = DataContext.Instance())
{
ctx.Execute(System.Data.CommandType.StoredProcedure, "dbo.ChangeGroupCode", oldCode, newCode);
}

Thanks, any help is appreciated

[bdukes]

There is not currently an exposed way to adjust the timeout. PetaPoco added a mechanism for setting the timeout in 2011, but DNN's DataContext does not currently expose that option. I don't see a way to adjust that other than via reflection.

[sleupold]

Did you consider improving indexes or using indexed queries?