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.
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:
- Q228843 “HOWTO: Implement Session Pooling from Visual Basic ADO Program” at http://go.microsoft.com/fwlink/?LinkId=15093.
- Q253803 “HOWTO: Invoke OLE DB Service Component Within an OLE DB Application” at http://go.microsoft.com/fwlink/?LinkId=15094.