Purge Process - Re-indexing SQL Tables?
A question has come up that I am not finding the answer for.... Does the daily purge process re-index EnsLib.HL7.SearchTable or other SQL tables? In looking at the purge process documentation I am not seeing anything that mentions EnsLib.HL7.SearchTable. Do we have to manually constantly re-index tables that we create? For example I created another search table based off of EnsLib.HL7.Search table, will I need to constantly watch this as it grows? How do tables get index, is there some kind of mechanism that automatically does it, or are we responsible for indexing tables ourselves? We are trying to evaluate our constant growth through additional messaging, orphaned messages, and etc..
Thanks
Scott
Comments
Hi Scott,
My understanding is that search table classes are maintained in Ens.DocClassMap. When you do a purge the Ens.MessageHeader appears to have the responsibility for calling RemoveSearchTableEntries() on the Ens.SearchTableBase which uses indirection to call RemoveIndex() on the class name maintained in the DocClassMap.
The docs briefly mention DocClassMap...
The Ensemble classes use this class to remove search table entries when message bodies are deleted.
Short answer, purges will automatically include new search tables even if you scheduled the purge before creating the search table.