Profile: vikarius

Thank you for your work. After your optimization your ajax filter  works  only 2-4 seconds in most hard cases. 1800 products in category(~6000 specification attibutes "Size").
You can check

http://obnowka.by/%D0%91%D0%B5%D0%BB%D0%BE%D1%80%D1%83%D1%81%D1%81%D0%BA%D0%B8%D0%B5-%D0%9F%D0%BB%D0%B0%D1%82%D1%8C%D1%8F-%D0%98%D0%BD%D1%82%D0%B5%D1%80%D0%BD%D0%B5%D1%82-%D0%BC%D0%B0%D0%B3%D0%B0%D0%B7%D0%B8%D0%BD

P.S. I have to update from nop 3.0 to 3.3

I sent all you need your support email. Hope you fix soon.

1800 products in category. Filter fails on timeout.

http://obnowka.by/%D0%B1%D0%B5%D0%BB%D0%BE%D1%80%D1%83%D1%81%D1%81%D0%BA%D0%B8%D0%B5-%D0%BA%D0%BE%D1%81%D1%82%D1%8E%D0%BC%D1%8B-%D0%B8%D0%BD%D1%82%D0%B5%D1%80%D0%BD%D0%B5%D1%82-%D0%BC%D0%B0%D0%B3%D0%B0%D0%B7%D0%B8%D0%BD

[code]Истекло время ожидания (Timeout). Время ожидания истекло до завершения операции или сервер не отвечает.
Детальная информация записи журнала.Полное сообщение:   System.Data.SqlClient.SqlException (0x80131904): Истекло время ожидания (Timeout). Время ожидания истекло до завершения операции или сервер не отвечает. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) в System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() в System.Data.SqlClient.SqlDataReader.get_MetaData() в System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) в System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) в System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) в System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) в System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) в System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) в Nop.Data.NopObjectContext.ExecuteStoredProcedureList[TEntity](String commandText, Object[] parameters) в SevenSpikes.Nop.AjaxFilters.Services.ProductServiceNopAjaxFilters.(IList`1 , SpecificationFilterModelDTO , AttributeFilterModelDTO , ManufacturerFilterModelDTO , Int32 , Int32 , Int32 , Int32  , Int32  , Nullable`1  , Nullable`1  , Nullable`1  , Int32  , String  , Boolean  , Boolean  , Int32  , ProductSortingEnum  , Boolean  ) в SevenSpikes.Nop.AjaxFilters.Services.ProductServiceNopAjaxFilters.SearchProducts(IList`1 categoryIds, SpecificationFilterModelDTO specifiationFilterModelDTO, AttributeFilterModelDTO attributeFilterModelDTO, ManufacturerFilterModelDTO manufacturerFilterModelDTO, Int32 pageIndex, Int32 pageSize, Int32 manufacturerId, Int32 storeId, Int32 vendorId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 productTagId, String keywords, Boolean searchDescriptions, Boolean searchProductTags, Int32 languageId, ProductSortingEnum orderBy, Boolean showHidden) в SevenSpikes.Nop.AjaxFilters.Controllers.Catalog7SpikesController.() в SevenSpikes.Nop.AjaxFilters.Controllers.Catalog7SpikesController.(Int32 , Int32 , PriceRangeFilterModel7Spikes , SpecificationFilterModel7Spikes , AttributeFilterModel7Spikes , ManufacturerFilterModel7Spikes , CatalogPagingFilteringModel , String  , Boolean  , String&  ) в SevenSpikes.Nop.AjaxFilters.Controllers.Catalog7SpikesController.GetFilteredProducts(Int32 categoryId, Int32 manufacturerId, PriceRangeFilterModel7Spikes priceRangeFilterModel7Spikes, SpecificationFilterModel7Spikes specificationFiltersModel7Spikes, AttributeFilterModel7Spikes attributeFiltersModel7Spikes, ManufacturerFilterModel7Spikes manufacturerFiltersModel7Spikes, CatalogPagingFilteringModel pagingFilteringModel, String queryString, Boolean shouldNotStartF