Storing huge XML files in DB or keep on filesystem
719416Aug 26 2009 — edited Aug 27 2009Is it a good idea to keep huge files in DB or keep them on filesystem. Users upload file which gets processed and the data is stored in respective tables. The files are copied to filesystem. Some of my colleagues suggested store the files in DB. Over a period of 1 year of so the files takes close to 3-4 terabytes of space.
The database to keep the file and database to store the data will be different. Should we keep in same database? If we keep in separate database then we have to manage the transaction, isn't it? Is there any advantage at all to keep the files in DB?
There is a disaster recovery site as well so the data gets synced to the DR site. We are looking to use disk storage sync between the two sites so even if I keep files in filesystem and the related data in database the DR site will never be in a position where the file system and database is not in sync.
We are planning to use Oracle 11G Standard Edition.