Derek,

Thanks for the response.

We have around 14 million documents in the repository and we have once tried to change a field values for 10,000 documents at once and it took around 14 hours.

Also, our client has system in use 24/7, so they don't really have off-peak hours.

I'd avoid Workflows in this case and create custom software to retrieve & export the docs via the SDK. By taking this route, you don't need to hit the Workflow engine and the resources that go with it.

We've done this for a modest (by comparison) 600,000 documents during production hours. Export time was about 3 seconds per doc (if I recall correctly) from time to search, load, export, and save meta data "export results" back. The database server took the hit, and we were able to increase database server specs on the fly for this project (cloud based).

I'd be interested to know how you approach this given the volume of docs you are tackling.

Thanks Michael,

I have some other workflows which will move all documents under a single folder with in the same Rep, so I would go for the route of simply selecting them in LF Client and export them out of LF as tiffs (File > Export >> Images). As this is a built in LF Client function, so I believe it will be more reliable than using a custom script (BTW I do have similar script as part of one of my other project, so i don't have to write one for this specifically anyways)

I could anyways export List of Contents to get the relevant metadata out as CSV.

I will let you now how it goes and any pros & cons of this.