Profiling your nopCommerce website with MiniProfiler

Here is the complete customized code:

@using Nop.Core.Domain.Common;
@using Nop.Core.Infrastructure;
@using Nop.Core;
@using Nop.Core.Domain.Customers;
@{
    var displayMiniProfiler = EngineContext.Current.Resolve().DisplayMiniProfilerInPublicStore;
 
    Html.AppendScriptParts("~/Scripts/public.ajaxcart.js");
    Html.AppendScriptParts("~/Scripts/public.common.js");
    Html.AppendScriptParts("~/Scripts/jquery-migrate-1.2.1.min.js");
    Html.AppendScriptParts("~/Scripts/jquery-ui-1.10.3.custom.min.js");
    Html.AppendScriptParts("~/Scripts/jquery.validate.unobtrusive.min.js");
    Html.AppendScriptParts("~/Scripts/jquery.validate.min.js");
    Html.AppendScriptParts("~/Scripts/jquery-1.10.2.min.js");
 
    //X-UA-Compatible tag
    var commonSettings = EngineContext.Current.Resolve();
    if (commonSettings.RenderXuaCompatible)
    {
        Html.AppendHeadCustomParts(string.Format("", commonSettings.XuaCompatibleValue));
    }
 
    IWorkContext _workContext = EngineContext.Current.Resolve();
    var isAdmin = _workContext.CurrentCustomer.IsAdmin();
 
}



    
    
    
    
    
    
    @Html.NopHeadCustom()
    @*This is used so that themes can inject content into the header*@
    @Html.Partial("Head")
    @Html.Widget("head_html_tag")
    @Html.NopCssFiles(this.Url, ResourceLocation.Head)
    @Html.NopScripts(this.Url, ResourceLocation.Head)
    @Html.NopCanonicalUrls()
    @Html.Action("RssHeaderLink", "News")
    @Html.Action("RssHeaderLink", "Blog")
    @*Favicon - upload favicon.ico file to the root directory*@
    @Html.Action("Favicon", "Common")
    @if (displayMiniProfiler && isAdmin)
    {
        @StackExchange.Profiling.MiniProfiler.RenderIncludes()
    }
    


    @RenderBody()
    @Html.NopCssFiles(this.Url, ResourceLocation.Foot)
    @Html.NopScripts(this.Url, ResourceLocation.Foot)

Now, if you save your changes and view the public store, you won’t see the profiler with loading time until you log in as “Admin” to your store site.

·        Hooking up MiniProfiler to an EF code first project in nopCommerce

MiniProfiler is also capable of profiling EF database calls. In order to do so, we will have to add the additional dependency of MiniProfiler.EF like this:

PM> Install-Package MiniProfiler.EF6

You can also install the package like this:

After installing the Nuget package for EF6, let’s add the necessary code in the “Global.asax.cs”:

·         Add this reference

using StackExchange.Profiling.EntityFramework6;

·         Add this in Application_Start()

MiniProfilerEF6.Initialize();

Basically, your Application_Start() will look like this:

protected void Application_Start()
        {
            MiniProfilerEF6.Initialize();
 
            //disable "X-AspNetMvc-Version" header name
            MvcHandler.DisableMvcResponseHeader = true;
 
            //initialize engine context
            EngineContext.Initialize(false);
 
            bool databaseInstalled = DataSettingsHelper.DatabaseIsInstalled();
            if (databaseInstalled)
            {
                //remove all view engines
                ViewEngines.Engines.Clear();
                //except the themeable razor view engine we use
                ViewEngines.Engines.Add(new ThemeableRazorViewEngine());
            }
…….
………………

…………………………

Now, if we run our website and view the public store, we will see the profiler with the loading time like this:

If you click on profiler, you will get the windows similar to this:

Here, you will notice that there is an additional column “sql” as the MiniProfiler is profiling our EF database calls. So, if you click on any loading time for SQL query, you will get the information like this:

Conclusion

It is simply amazing to see that MiniProfiler is profiling the database calls while any page is loading. We can see the time takes for each query on this page and this is a great way for developers to keep an eye on the performance of the nopCommerce website. In any case, the site or webpage is loading slow, the developer can troubleshoot the problem and improve the performance.

·         nopCommerce can be download here: http://www.nopcommerce.com/downloads.aspx

·         nopCommerce Version (used in this article): Version 3.70

·         nopCommerce Support: http://www.nopcommerce.com/boards/