148384
Extreme Lag After Updating to Sedona Office version 6.2.0.21
After updating to Sedona Office version 6.2.0.20 or .21, some users may experience significant lag in the program. This is especially noticeable in the Accounts Payable (AP) modules when attempting to create a new Deposit. There are two scripts to run for this situation.
The first is:
USE [ReplaceWithCompanyDatabaseName]
GO
CREATE NONCLUSTERED INDEX [IX_Deposit_Batch_ID]
ON [dbo].[AR_ACH_Batch] ([Deposit_Batch_Id])
INCLUDE ([Funding_Id],[Funding_Status],[Funding_Date])
GO
This will create the new index for Deposits.
The second is:
-- Remove all GL_Account indexes and re-add proper ones.
declare @IdxName nvarchar(255), @sql nvarchar(500);
set @IdxName = (
select constraint_name
from information_schema.table_constraints
where table_name = 'GL_Account' and constraint_type = 'primary key'
);
if isnull(@IdxName, '') <> ''
begin
set @sql = 'alter table GL_Account drop constraint ' + @IdxName;
execute sp_executesql @sql;
end
go
declare @IdxName nvarchar(255), @sql nvarchar(500), @done bit;
set @done = 0
while @done = 0
begin
set @IdxName = (
select top 1 i.[name]
from sys.indexes i
join sys.objects o on o.object_id = i.object_id
where i.[type] > 0 and o.[name] = 'GL_Account'
);
if @IdxName is null
begin
set @done = 1;
end
else
begin
set @sql = 'drop index ' + @IdxName + ' on GL_Account';
execute sp_executesql @sql;
end
end
go
alter table GL_Account
add constraint PK_GL_Account primary key clustered (Account_Id);
go
create index ix_Account_Code on GL_Account (Account_Code);
go
create index ix_Account_Type_Id on GL_Account (Account_Type_Id);
go
create index ix_Vendor_Id on GL_Account (Vendor_Id);
go
This will clean up any scattered indexes on other tables leading to the slowdown.
