Join us this Friday for AI in Action at the Virtual Happy Hour! This free virtual event is open to all—enroll now on Academy and don’t miss out.
AI OnAI Off
Find performance issues and IndexingQueueReference Store in tblBigTable
Guess they want to first store what should be indexed and then try to call external service to update index. Makes sense to avoid data getting lost because of failing connection, performance etc...
Jan 09, 2017 10:03
Hey Experts,
FIND version 12.1.0, CMS 9.12
Just had some performance issues on saving, creating, moving, deleting IContent.
The problem was 50 000 rows in DDS store IndexingQueueReference. Some kind of queue to FIND indexing.
By deleting all items all worked fine again.
EPiServer.Data.Dynamic.DynamicDataStoreFactory.Instance.GetStore(typeof(EPiServer.Find.Cms.IndexingQueueReference)).DeleteAll();
Anyone with insight can explain how FIND uses this Store?
Any idea why this queue was stoped and just growing?
In later version i understand it it using a new table tblFindIndexQueue, probably to boost performance...?
Many Thanks to you who can enlight me =)