Odoo Help

Welcome!

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

1

ODOO9: which is better filestore or database store

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

Hello!!

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

Thanks a lot :)

3

Yenthe

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

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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