Is it possible to store documents in a different database than the main one?
We're developing a system which will store a huge amount of documents, some of which will be videos and they can be very big.
No. After considering the pros and cons for very large document bases a database was not a favorable option. The backups would be too big, there would be no indexing benefit in dealing with binaries, and using filestream would just be an extra indirection.
For large document bases the recommendation is to use redirect the documents to disk. You don't need to change any of your interface patterns. You just need to activate the setting in the client definition:
This will save only the filename path in the database. The file will be saved in your configured document folder, so don't forget to set it correctly in WebAdmin (System configuration > Application > Document path) and give it appropriate write permission when you deploy your solution.
About the Community
|Asked: 10/15/19, 7:02 AM|
|Seen: 1140 times|
|Last updated: 10/16/19, 9:15 AM|