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.
|