Take the 2-minute tour ×
Tridion Stack Exchange is a question and answer site for Tridion developers and administrators. It's 100% free, no registration required.

I have some issues with the original implementation of Binary file storage being placed in the Broker database. In a recent deployment we decided to utilize File system storage in favour of performance impacts on the Broker database itself.

This has worked well for that particular project, however is there a way we can now change how other projects work in retrieving all of the Binary items from the Broker database, placing them on the File system and serving that way?

Would like to perform this WITHOUT having to republish entire sites, due to the sheer amount of content that would not be practical.

Thanks

Martin

share|improve this question

1 Answer 1

Given that it's not just a question of moving the files (their metadata must be adjusted too) I would really prefer to do it via republishing. I know you say it's unpractical/time consuming, but it is the safest way to do it.

If this is really not an option, then I would:

  • Compare thoroughly the differences (in metadata) between a binary in the File System vs a Binary in the Database (with a bit of luck, there's no difference)
  • Write some code using the CD API to retrieve the binaries and store them in the right location in the File System (making sure it matches the metadata)
  • Change cd_storage_conf.xml to reflect the new location of the binaries

This should do it.

One of the biggest advantages of storing Binaries in the database is distribution of the same binaries. If you have a multiple server farm, not having to deploy to multiple file systems can be a significant advantage, and when coupled with caching I have not see performance issues with this approach before. What is arguably the largest SDL Tridion deployment in terms of page views uses this model.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.