Dear Sirs,
We are having some performance issues on our site when loading the following 4 pages:
https://www.kitegb.com/womens-glasses
https://www.kitegb.com/womens-designer-sunglasses
https://www.kitegb.com/designer-glasses-for-men
https://www.kitegb.com/designer-sunglasses-for-men
We are running nopcommerce 3.2. We have pinpointed the issue in the query for nopcommerce but are not sure how to improve the speed. It seems like the server for nopcommerce is taking a long time to respond. Please help, code below.
ntdll!NtWaitForSingleObject+c
KERNELBASE!WaitForSingleObjectEx+8f
KERNELBASE!WaitForSingleObject+12
System_Data!SNIReadSyncOverAsync+84
System_Data_ni!DomainNeutralILStubClass.IL_STUB_PInvoke(SNI_ConnWrapper*, SNI_Packet**, Int32)+44
System_Data_ni!DomainNeutralILStubClass.IL_STUB_PInvoke(SNI_ConnWrapper*, SNI_Packet**, Int32)+44
[[InlinedCallFrame]]
System_Data_ni!SNINativeMethodWrapper.SNIReadSyncOverAsync(System.Runtime.InteropServices.SafeHandle, IntPtr ByRef, Int32)+4b
System_Data_ni!System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()+66
System_Data_ni!System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()+28
System_Data_ni!System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()+41
System_Data_ni!System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte ByRef)+57
System_Data_ni!System.Data.SqlClient.TdsParser.TryRun(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject, Boolean ByRef)+df
System_Data_ni!System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()+3e
System_Data_ni!System.Data.SqlClient.SqlDataReader.get_MetaData()+5b
System_Data_ni!System.Data.SqlClient.SqlCommand.FinishExecuteReader(System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.RunBehavior, System.String)+11d
System_Data_ni!System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, Boolean, Int32, System.Threading.Tasks.Task ByRef, Boolean, System.Data.SqlClient.SqlDataReader)+1ef
System_Data_ni!System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String, System.Threading.Tasks.TaskCompletionSource`1<System.Object>, Int32, System.Threading.Tasks.Task ByRef, Boolean)+b2
System_Data_ni!System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String)+36
System_Data_ni!System.Data.SqlClient.SqlCommand.ExecuteReader(System.Data.CommandBehavior, System.String)+8a
System_Data_ni!System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(System.Data.CommandBehavior)+2a
System_Data_ni!System.Data.Common.DbCommand.ExecuteReader()+d
Nop_Data!Nop.Data.NopObjectContext.ExecuteStoredProcedureList[[System.__Canon, mscorlib]](System.String, System.Object[])+233
Nop_Services!Nop.Services.Catalog.ProductService.SearchProducts(System.Collections.Generic.IList`1<Int32> ByRef, Boolean, Int32, Int32, System.Collections.Generic.IList`1<Int32>, Int32, Int32, Int32, Int32, Int32, System.Nullable`1<Nop.Core.Domain.Catalog.ProductType>+1ce0
Nop_Services!Nop.Services.Catalog.ProductService.SearchProducts(Int32, Int32, System.Collections.Generic.IList`1<Int32>, Int32, Int32, Int32, Int32, Int32, System.Nullable`1<Nop.Core.Domain.Catalog.ProductType>, Boolean, System.Nullable`1<Boolean>, System.Nullable`1<S+cb
Nop_Web!Nop.Web.Controllers.CatalogController.PrepareProductOverviewModels(System.Collections.Generic.IEnumerable`1<Nop.Core.Domain.Catalog.Product>, Boolean, Boolean, System.Nullable`1<Int32>, Boolean, Boolean, Boolean)+2457
Nop_Web!Nop.Web.Controllers.CatalogController.Category(Int32, Nop.Web.Models.Catalog.CatalogPagingFilteringModel)+2d36
DynamicClass.lambda_method(System.Runtime.CompilerServices.Closure, System.Web.Mvc.ControllerBase, System.Object[])+93
System_Web_Mvc!System.Web.Mvc.ActionMethodDispatcher.Execute(System.Web.Mvc.ControllerBase, System.Object[])+f
System_Web_Mvc!System.Web.Mvc.ReflectedActionDescriptor.Execute(System.Web.Mvc.ControllerContext, System.Collections.Generic.IDictionary`2<System.String,System.Object>)+9d
System_Web_Mvc!System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(System.Web.Mvc.ControllerContext, System.Web.Mvc.ActionDescriptor, System.Collections.Generic.IDictionary`2<System.String,System.Object>)+1c
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__36(System.IAsyncResult, ActionInvocation)+17
System_Web_Mvc!System.Web.Mvc.Async.AsyncResultWrapper+WrappedAsyncResult`2[[System.__Canon, mscorlib],[System.Web.Mvc.Async.AsyncControllerActionInvoker+ActionInvocation, System.Web.Mvc]].CallEndDelegate(System.IAsyncResult)+1e
System_Web_Mvc!System.Web.Mvc.Async.AsyncResultWrapper+WrappedAsyncResultBase`1[[System.__Canon, mscorlib]].End()+32
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(System.IAsyncResult)+21
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker+AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3c()+33
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker+AsyncInvocationWithFilters+<>c__DisplayClass45.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3e()+2d
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker+AsyncInvocationWithFilters+<>c__DisplayClass45.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3e()+2d
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker+AsyncInvocationWithFilters+<>c__DisplayClass45.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3e()+2d
System_Web_Mvc!System.Web.Mvc.Async.AsyncControllerActionInvoker+AsyncInvocationWithFilters+<>c__DisplayClass45.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3e()+2d
< clipped >>