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

Publicaciones relacionadas	Respuestas	Vistas
Attachements attachments	0 dic 24	1497
How to set attachments to public? Resuelto attachments	1 mar 23	6715
How to automatically change name of ir.attachment Resuelto attachments	2 abr 22	4155
Remove product attachment without deleting the document attachments	0 oct 21	2674
How know if a product has attachments from the list view Resuelto attachments	2 may 20	12253

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!