I have the following situation with one of our clients:
They are using NAV to create documents and indexes for these documents. With DocuWare Import they are importing the image of the document in DocuWare and after that, using Autoindex, they fill in all the indexes in DocuWare. Sounds good, and works. But where is the problem - they have more than milion records in NAV, and are creating thousands of records every week (sometimes even thousands of records every day). Also, their server is heavy loaded. So they need to decide how to:
1. Read only the new records in NAV, by DocuWare Autoindex (not thousands of them);
2. Mark successfully processed records (by DocuWare Autoindex) in NAV so they don't need to be read again(this will be the best option);
I created an additional field in NAV database, which I can use as marker (1 - successfully processed, 0 - not processed). Created Autoindex which reads records in NAV, marked as 0. Then created second Autoindex, which reads records in DocuWare, newer than 1 day, and for them, updates the marker in NAV from 0 to 1.
In this situation client has two Autoindex processes for one function. As I wrote, their server is heavy loaded and runing several autoindex processes at the same time is not OK.
So, after these boring explanations, I want to ask You if You have any idea, how to manage this situation with less server load and more accuracy, because in my configuration, if the second Autoindex fail for some reason, there will be no sign in NAV.
I am waiting for your ideas.