J
James Palmer
Guest
I'm afraid I don't have an answer to why it's not working, but wanted to chip in with my 2p. In my opinion (and from experience!), it is a really bad idea to be storing documents within LOBs, particularly to the point where you are considering compressing them. I can understand the draw to do this, heck that's why we did it in the first place too - keep everything together under one roof, secure and easy to access. The reality is, that LOBs are a real pain when it comes to doing any DBA work that requires moving stuff around. They bloat the database and greatly increase the maintenance time required for all sorts of activities. Even compressed, our LOBs comprised nearly 50% of the database. Backups, restores, Replication, Dump and Load, etc, etc were all negatively impacted by this. The database is not a filestore. It's a database. In the end the solution we came up with was to have a file store created which only administrators and one user had access to. The user that had access was owned by an AppServer process. The AppServer pushed and pulled the files (the filenames were obfuscated by the AppServer to make it hard for any person to fiddle around). We had a small table within the database that was the link between obfuscated file names and real file names, so we could present a file in it's real format to the user. It would be a bit of effort to get all set up, but once done the database will be a lot leaner, and the file system with the files is now under standard system backups and maintenance, and you save hours a month on routine maintenance jobs.
Continue reading...
Continue reading...