Alfresco version : 5.0.c Community, Share
I'm wondering if there are any known issues with storing large numbers of documents in a given folder with the default installation using PostgreSQL. Total number of docs is likely in the range of 10-20k.
My use case: creation of a metadata searchable archive of (mostly handwritten, non-indexable) TIFF documents. Once the users have entered the metadata, the documents will only be retrieved by search, not by directly browsing the folder structure.
Currently planned implementation: documents imported, users enter metadata, documents are sent to a folder for QC, then moved to a final archive folder.
Plan if this will cause issues: create a custom action type that extracts the year and month from the document date, and moves the document to a corresponding yyyy/mm folder structure (or creates the folder if it doesn't exist). We know this will result in folders with less than a few hundred documents each.
Thanks for any help. If this is an issue and my backup plan is flawed, I'd appreciate any feedback if there is a more efficient or just plain better way to move the documents to final storage.
