Odoo Help


ODOO9: which is better filestore or database store

Drees Far
on 3/23/16, 4:05 AM 704 views


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

Thanks a lot :)



| 7 7 8
Turnhout, Belgium

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

Drees Far
on 3/23/16, 4:30 AM

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

on 3/23/16, 5:09 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 704 times
Last updated: 3/24/16, 4:10 PM