Performance Problem for the OrderGroup Object

There may be a long delay (25-30 seconds) in the OrderGroup.SaveAsOrder method, or in other OrderGroup methods.

Solution

This problem appears when there are no open connections in the MDAC pool, so the connection pool is shut down and then recreated on the next access. The workaround is to keep a single connection open for the life of the site or application so the pool never shuts down.

This is not an issue in the ASP Solution Sites (they hold at least one connection open). Nor is it an issue with the Commerce Server .NET Application Framework, which keeps a connection open using the connection string for the Transactions database.

However, sites that use Commerce Server but do not use one of these frameworks can encounter this issue.

For more information, see the following Knowledge Base articles:

Copyright © 2005 Microsoft Corporation.
All rights reserved.