Im in the process of making a lock on this file for a version 2. In version 3 the file is deleted. Would it be an idea to remove this file from v2 as well and people will have to make custom sql if they need advanced data?

Kind regards
Anders

Hey :) 

First of all i guess i cannot reduce this file in any way right ? as of the current solution i am talking about ? And that it sometimes regenerates the full file.

On the thought of v2 and advanced data what are you thinking here ? 

Can you send a stack trace of what happens when you get the timeout?

Of course you can :)

Another quick question, in TC 2.x is there a method to get all finalized orders as orders and not XML :) 

2015-01-05 07:47:41,070 [8] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 39] An unhandled exception occurred
System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at TeaCommerce.Api.Persistence.Database.ExecuteScalar[T](Sql Sql)
   at TeaCommerce.Api.Persistence.Database.Page[T](Int64 page, Int64 itemsPerPage, String sql, Object[] args)
   at TeaCommerce.Api.Persistence.Repositories.OrderRepository.Search(Int64 storeId, Int64 orderStatusId, String orderNumber, String firstName, String lastName, Nullable`1 paymentState, Nullable`1 startDate, Nullable`1 endDate, Nullable`1 isFinalized, Int64 page, Int64 itemsPerPage)
   at TeaCommerce.Api.Services.OrderService.Search(Int64 storeId, Int64 orderStatusId, String orderNumber, String firstName, String lastName, Nullable`1 paymentState, Nullable`1 startDate, Nullable`1 endDate, Nullable`1 isFinalized, Int64 page, Int64 itemsPerPage)
   at TeaCommerce.Umbraco.Application.Views.Orders.SearchOrders.Search()
   at TeaCommerce.Umbraco.Application.Views.Orders.SearchOrders.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ClientConnectionId:f15b9c2e-4a1b-4164-b014-b8c5f2a792dd
Error Number:-2,State:0,Class:11
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.umbraco_plugins_tea_commerce_views_orders_searchorders_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Even local im getting this when i have a decent amount of orders.

Do you have a slow SQL? :)

Its the search method that uses paged sql so it should be pretty quick. Have you done something custom code that searches in a different way? We have shops with 10000+ orders which run fine.

Kind regards
Anders

Nothing at all. I have other shops running aswell with x000 of orders but its on 1.x.

Its running on an Azure SQL, so should be okay.

The customer called this morning and timed it to 6 min(i upped the executing timeout) on the request before it failed in the message.

 Only thing that is special is that im in the shop overview(this is what she opens when it takes along time) and in the overview im pulling 2 order properties.

 its a tc 2.3.2 and umbraco 6.1.6

Could you try and not pull those 2 properties and see if that helps? Do you have custom cs file or just the view that is custom?

is working on a reply...