Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > CHANGE Store files in database -> in file system View modes: 
User avatar
Member
Member
eagleag - 10/8/2010 12:46:48 AM
   
CHANGE Store files in database -> in file system
HI,
I have a site up that already has some products in it and I noticed that in sitemanager the FILES setting is : Store files in database.
I would like to change this to Store files in file system.
If I change it will this somehow take all images that are already in the site and move them to file system?
If I would like that to happen how can I achieve his?


THANKS :)

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 10/8/2010 5:12:23 AM
   
RE:CHANGE Store files in database -> in file system
Hi,

if you save the File document it will save the attachment to disk. You can simply hit the Save button on all documents with images. You coud also update the nodes by API if you need to do it programmatically.


Best regards,
Helena Grulichova

User avatar
Member
Member
hi1ton - 10/8/2010 11:50:54 AM
   
RE:CHANGE Store files in database -> in file system
Hi Helen

When is it best to save items in the Database and when is it better to store them in the file system?

Thanks
Hilton

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 10/12/2010 4:07:56 AM
   
RE:CHANGE Store files in database -> in file system
Hi Hilton,


Storing in file system improves the performance. It is much faster to get the file from file system than from database. You only need the disk space in file system...


Best regards,
Helena Grulichova

User avatar
Member
Member
hi1ton - 10/12/2010 4:22:25 AM
   
RE:CHANGE Store files in database -> in file system
Thanks Helen

So if I change this once the site already has data in it only items the new documents created afterwards will be in the file system and the items before changing the setting will still be in the Database?

If so, then we can use the api to re-save all the documents and on re-saving they will be saved in the file system?

thanks,

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 10/12/2010 6:28:27 AM
   
RE:CHANGE Store files in database -> in file system
Hi,

the files are always in database. If you uncheck Store files in database it will never get them from database (but they are there). Only if you check Store files in file system afterwards they are not there immediately but after update.

Hope it makes sense.

Best regards,
Helena Grulichova