CheckAllExpenses too slow

[bryaleks]

Тут нужно оптимизировать, обсудим на дейли

Function GetExpenseRecorders(Parameters) Query = New Query(); Query.TempTablesManager = Parameters.TempTablesManager; Query.Text = "SELECT | BalanceRegister.Recorder, | BalanceRegister.Recorder.PointInTime |FROM | AccumulationRegister.%1 AS BalanceRegister | INNER JOIN Records_All_Grouped AS Records_All_Grouped | ON Records_All_Grouped.Store = BalanceRegister.Store | AND Records_All_Grouped.ItemKey = BalanceRegister.ItemKey | AND BalanceRegister.RecordType = VALUE(AccumulationRecordType.Expense) |GROUP BY | BalanceRegister.Recorder, | BalanceRegister.Recorder.PointInTime |ORDER BY | BalanceRegister.Recorder.PointInTime DESC"; Query.Text = StrTemplate(Query.Text, Parameters.RegisterName); QueryResut = Query.Execute(); QueryTable = QueryResut.Unload(); Return QueryTable; EndFunction

Function CheckAllExpenses(Parameters) Result = New Structure("IsOk", True); // bilist-alex< Return Result; // bilist-alex>