Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Can I switch form "Store files in file system" to "Store files in database" without breaking things? View modes: 
User avatar
Member
Member
john-wakefly - 7/29/2009 8:23:14 AM
   
Can I switch form "Store files in file system" to "Store files in database" without breaking things?
Will switching the site manager settings to "Store files in file system" instead of "Store files in database" break anything?

Will it copy existing files form the DB into the filesystem? Or will it just affect future files?

Documentation clearly states that the latter setting (which is default out of box setting) will decrease performance. That is what I'm currently using, and performance is extremely slow.

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 7/29/2009 9:56:34 AM
   
RE:Can I switch form "Store files in file system" to "Store files in database" without breaking things?
Hi John,

well, at the moment you switch storing files from database only to file system only, nothing wrong will happen. The files from database will be copied only if they are requested.

However, the future - newly added files will be stored only in filesystem. The biggest disadvantage of storing files in filesystem only is that if you later decide to switch to store the files in DB only, files from filesystem will be lost.

We recommend to use (enable) both storage options, since storing files in database provides better reliability (DB backups) and allows e.g. full-text search in files, while the filesystem storage improves performance. In this case the storage of files in DB doesn't slow pulling the files from filesystem.

Hope this makes sense.

If you experience some severe performance issues, it is best to perform diagnostics to find the bottleneck, e.g. using SQL profiler and other methods.

Best regards,
Zdenek C.

User avatar
Member
Member
webwise - 8/4/2009 8:23:11 AM
   
RE:Can I switch form "Store files in file system" to "Store files in database" without breaking things?
How does "Redirect files to disk" affect this?

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 8/4/2009 8:51:28 AM
   
RE:Can I switch form "Store files in file system" to "Store files in database" without breaking things?
Hello,

If this settings is checked it means it gets the files from disk. Please see here: http://devnet.kentico.com/docs/devguide/where_the_files_are_stored.htm for more details.

Best regards,
Helena Grulichova