Compress mime tables in database

Moderator: crythias

Post Reply
rodolfor
Znuny newbie
Posts: 89
Joined: 11 Jun 2020, 14:56
Znuny Version: 6.0.27
Real Name: Rodolfo Rughi
Company: none

Compress mime tables in database

Post by rodolfor »

Hi,
I know it is a database systemist question, but I am going to try to compress tables in article_data_mime_attachment and article_data_mime_plain.
I will try to enable page_compression method.
Is there any advice in going this route?
thanks!

RR
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Compress mime tables in database

Post by jojo »

why not saving the attachments on disc instead in database?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
rodolfor
Znuny newbie
Posts: 89
Joined: 11 Jun 2020, 14:56
Znuny Version: 6.0.27
Real Name: Rodolfo Rughi
Company: none

Re: Compress mime tables in database

Post by rodolfor »

Because the size problem is the same?
Mime data, if compressed require approx 20% of space.
If I save them in the filesystem does it save space for the different encoding?
If yes, ho can I convert actuale mime data in filesystem?

Thanks
Post Reply