Odoo Help

1

ODOO9: which is better filestore or database store

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

Hello!!

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

Thanks a lot :)

3

Yenthe

--Yenthe--
7020
| 7 7 8
Turnhout, Belgium
--Yenthe--

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

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

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

Yenthe

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

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

Register

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)

Stats

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