11-14-2017 08:45 AM
Hi all!
I have a situation where I need to add a "closed date"keyword to some of our documents so that we can purge them.
We have discovered that there are approximately 12.5 million documents the the KW updater will need to go through in order to add the keyword to the appropriate ones.
I understand that this can be very system intensive. I'm trying to understand HOW system intensive, so I can set up the correct process(s) and schedule them properly.
Is 12.5 million documents doable in a few hours (assuming I choose "global")? or would it be better for me to break it up and do batches of document types? I will be running a test, but would like to have some inkling of what to expect. 🙂
Thank you!
Liz
Amplify Credit Union
12-20-2017 05:50 AM
Hi Liz.
My company has been using Onbase for 3-4 months now, and my experience with Keyword Updater is mixed. It seems to work much slower than expected, and we have not managed to update high volumes of documents. Neither when using Keyword Update - Global nor Keyword Update – Doc Type. The processing time per document is too high. If I remember correctly 20 mill docs would take about 30 days.
When we had the need to update a keyword globally the Hyland database team helped us by executing an sql directly in the database. This worked fine, but is not best practice.
My experience is the KW updater is only functional when the update can be limited to a small number of documents, in example a DT containing relatively few documents. The handling time per document is still much higher than what is expected, but a limited number of documents keeps total processing time down.
I am trying to understand if document handle or other parameters or keyword can be used to limit KW update volumes, and will probably do some testing in the coming weeks.
I would be most interested to know how the high volume keyword update worked for you, and what was your chosen strategy.
Thanks
Trond Andersen, Sparebank1 Insurance, Norway
12-20-2017 06:00 AM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.