where are pictures & attachments saved?

Question

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? S

Dharmesh Rathod · Answer

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 [1]
http://acespritechblog.wordpress.com [2]

[1] http://www.acespritech.com
[2] http://acespritechblog.wordpress.com

patrick · Answer

Attachments are stored at ir_attachment.

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

Borni DHIFI · Answer

Hi,

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

[1] http://www.baconconsult.eu/home/our-products/openerp/knowledge-management

Related Posts	Replies	Views
How to set attachments to public? Solved attachments	1 Mar 23	4211
How to automatically change name of ir.attachment Solved attachments	2 Apr 22	2003
Remove product attachment without deleting the document attachments	0 Oct 21	1552
How know if a product has attachments from the list view Solved attachments	2 May 20	10727
Odoo create attachement automatically attachments	2 Dec 17	2945

This question has been flagged

Enjoying the discussion? Don't just read, join in!