AspDotNetStorefront Performance Enhancements by MoCo

Enhance SQL Performance

• Improve query cache plan through Query Parameterization and gain faster results from SQL Server
• Specify result set when applicable
• Condense/reduce number of calls to SQL when applicable
• Optimize xml packages to use global variables and templates
• Profile table
• Customer ZERO fix

Features AppConfig(s) to disable unused features that do not already have an AppConfig, reducing number of calls to SQL. If not in use they are expensive SQL operations.

• Dynamic Customer Roles
• Related Products
• Upsell Products
• Other existing operations when applicable

*Source code access required. SaaS sites (preFIX and similar) are not compatible with this service.