Since you are using a plug-in, you can rid of some of the Connection Items you have, they are not necessary. The Plug-In Context already has what you need to instantiate the OrganizationServiceProxy (see below:)
public void Execute(IServiceProvider provider)
{
IPluginExecutionContext context = (IPluginExecutionContext)provider.GetService(typeof(IPluginExecutionContext));
IOrganizationService _service = null;
_service = ((IOrganizationServiceFactory)provider.GetService(typeof(IOrganizationServiceFactory))).CreateOrganizationService(new Guid?(context.UserId));
}
While it may not be the cause of the issue, I think it's a little better way of getting your service proxy setup. The Quote Entity in CRM has a lot of fields on it, it may be worth doing the following:
1. Instead of retrieving the Quote in your code, have you looked at adding a PreImage to your plug-in? This will allow you to pull in the fields & values from the Order before the State Code change. From there you can cast your PreImage as
an Entity and reference all of the properties. This will save you a call to server.
2. If you'd rather retrieve the Quote instead of a PreImage, can you limit the fields that you are returning from the Quote? Instead of doing new ColumnSet(true), do new ColumnSet(new string[] {"quoteid","quotenumber",etc....)}
I would definitely look at these suggested changes as an option but I would also recommend doing what Jamie is suggesting as well. The Query shouldn't take 99 seconds to run, definitely sounds like there could be some SQL issues causing slow performance
on that table.
Jeremy
Jeremy Winchell Avtex http://blog.avtex.com
