Timeout setting for ContentRepository.Save(...)

Vote:
 

Hi!

Sometimes when I call IContentRepository.Save(...) I get an SQL timeout. I can only assume that this is due to a large product database with a number of meta fields, which leads to a huge MetaKey-table. The call will time out after 30 seconds, but I would like to increase this. Where can I find this setting?

I'm using EPiServer Commerce 8.11.

Regards

Andreas

#120260
Apr 14, 2015 11:16
Vote:
 

Okay, so I can see that it's actually MetaDataCommiter.CommitMetaAttributes(...) and then MetaObject.AcceptChanges(...) that "triggers" the timeout. In MetaObject.AcceptChanges(...) we can see a call to MetaDataPlusDatabase.UpdateMetaObject(...) which in its turn calls MetaDataPlusDatabase.StoredProcedure(...).ExecuteNonQuery(...). The last step is to call DBHelper.ExecuteNonQuery(...) and this is "where the fun ends". It seems there is no way to set the command timeout.

Suggestions?

#120263
Apr 14, 2015 11:55
Vote:
 

Unfortunately IContentRepository.Save<EntryContentBase> is a big operation which involves both CMS and Commerce databases. You'll need to make sure which database is actually timeout.

If it's on Commerce side then one possible solution is to create a class inherit from SqlDataProvider which adjust the CommandTimeOut in DataCommand to the value you need, then register it in web.config/FrameworkProviders as the default provider for dataService.

The good news is we are working on a new version (possibly Commerce 9) which drastically improve the performance of IContentRepository.Save. After that the solution above should no longer be needed.

Regards.

/Q

#120264
Apr 14, 2015 11:59
Vote:
 

Hey!

Inheriting SqlDataProvider is probably exactly what I need!

Trying it out just using this code now...

public class ClientSqlDataProvider : SqlDataProvider
{
	public override DataResult ExecuteNonExec(DataCommand command)
	{
		command.CommandTimeout = CatalogConfiguration.Instance.Connection.CommandTimeout;
		return base.ExecuteNonExec(command);
	}
}

... and registering in FrameworkProviders just as you suggest. It seems to do the job!

You, my friend, is a true hero! The hero that Gotham deserves!

#120266
Edited, Apr 14, 2015 12:12
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.