Odoo Help


ODOO9: which is better filestore or database store

Vale Trood
on 3/23/16, 4:05 AM 1,088 views


Can anyone explain to me which solution is better: the filstore or the database store.

Thanks a lot :)



| 8 8 8

My Odoo blog: http://www.odoo.yenthevg.com/

My Twitter: https://twitter.com/Yenthe666

On 3/23/16, 4:23 AM

Hi Drees,

I'd say this really depends on how many files / attachments you'd like to manage in Odoo.
When you have 100GB of files and put them in the database you will see quite some performance loss since everything is in the database and needs to be queried.
When your files are in a filestore (in essence just a folder structure on your server) the Odoo will keep track of the locations of the files but the files itself are not stored in the database, which improves query speeds quite a lot. 
So if you have a lot of files go with the filestore, if you just have some files it doesn't really matter a lot.


Thanks a lot Yenthe :) Always in service my friend

Vale Trood
on 3/23/16, 4:30 AM

No problem! Thank you for accepting the answer. :)

on 3/23/16, 5:09 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/23/16, 4:05 AM
Seen: 1088 times
Last updated: 3/24/16, 4:10 PM