Due to table definition changes in Mekorma build x96, the table maintenance routine time may increase greatly.

December 20, 2024 17

 

 

                                                                                                                                                                                                                      Run the following query where DYNAMICS is the system database. Note for each company there is a count.Total the numbers in order to estimate the additional time it will take to process the Mekorma table maintenance upgrade routine. Observed benchmarks suggest to add an additional 30 minutes of process time per 10 million rows. 

 

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

exec sp_MSforeachdb
' use ?
if exists ( select INTERID from DYNAMICS..SY01500 D where INTERID = ''?'' )
begin
    print ''Processing database ?''
  select CMPNYNAM AS GP_DYNAMICS_COMPANY_NAME from DYNAMICS..SY01500 D where INTERID = ''?'' 
select COUNT (*) from ME240457
end’

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<