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.

0

where are pictures & attachments saved?

By
gunnar
on 6/21/13, 9:51 PM 2,339 views

I am trying to understand a little better how big things will be getting, or where you'll need the most space on a linux (debian/ubuntu) system.

I guess the most storage hungry components might be pictures or other attachments to any product. I have no idea how a database works, so can anybody explain the principle? Are these kind of files actually inside one big database file or are they separated and only linked to entrie's in the database? As far as I know the database is in /var, correct? So, do I need to be /var on a partition with much space?

1
Dharmesh Rathod
On 6/22/13, 1:54 PM

Hi,

Attachments are storing in field of datatype "bytea". Attachments are converting into "binary string" and that sting store into field.

If file size is big, length of string will be also big and it will take more size of disk. It may possible to increase size in case allocation size of disk will full.

Thanks
Acespritech Solutions Pvt Ltd
http://www.acespritech.com
http://acespritechblog.wordpress.com

eventhough i dont understand these answers really, it seems to me that this is part of the database. so i assume, the pictures you have, the bigger the database gets, right?

gunnar
on 6/23/13, 9:19 PM
0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 6/22/13, 5:04 PM

Attachments are stored at ir_attachment.

Images from products are stored at products_products.image_small or image_medium or image_large.

0

Borni DHIFI

--Borni DHIFI--
5102
| 6 8 9
Tunis, Tunisia
--Borni DHIFI--

Techno Functional Consultant Odoo(OpenERP) 

http://www.linkedin.com/in/borni

Skype : dhifi.borni

Borni DHIFI
On 6/22/13, 5:53 AM

Hi,

This article it can help you to understand principle of Knowledge Management Module in OpenERP.

not sure whether that has wnything to do with my question ... I have no question about the Knowledge Management Module.

gunnar
on 6/22/13, 11:28 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: 6/21/13, 9:51 PM
Seen: 2339 times
Last updated: 3/16/15, 8:10 AM