Users noticed that gazetteer load times have doubled. The loading of the type 17/type 67 records times have doubled and in some cases tripled while processing these records.
To fix this issue please follow steps below:
1. Analyze tables
analyze table Nm_Inv_Items_All compute statistics; analyze table Nm_Nw_Ad_Link_All compute statistics; analyze table Nm_Elements_All compute statistics;
analyze table Nm_Inv_Items_All compute statistics;
analyze table Nm_Nw_Ad_Link_All compute statistics;
analyze table Nm_Elements_All compute statistics;
2. Find out the old loader batches that have a lot of type 67 records and for 17 records using scripts below
Select Batch_Id, Count(*) From Nsg_Loader_Type_67_RecsWhere Processed_Flag = 'N'Group By Batch_Id;
Select Batch_Id,Count(*) From Nsg_Loader_Type_17_RecsWhere Processed_Flag = 'N'Group By Batch_Id;
and purge these batches.
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!