Index for MigrationID
First of all, there is no option for selecting the key word of "Migration" in the dropdown so I had to use "Storing". I'm guessing migration isn't at issue for most. I'm with a company that is migrating from FORTIS to Docuware. I'm not sure how many companies have gone through a migration that have just under 20 million documents and 18 Terabytes of images, but you should really think about creating an index for the MigrationID. When you initially start migrating, you don't see an issue. Once your cabinet gets up to around a couple of million records, the migrations starts timing out due to it having to look at the millions of records that are already stored to see if it has already been migrated. This issue created hours of trying to debug the issue along with multiple phone calls to our vendor. It is a simple fix and should have been implemented from the start.
William Jeffries
shared this idea
Thank you for your idea. Unfortunately, due to several factors we are currently not able
to plan this idea for a future version.