Dear Ken; I will like that branch... and hope it to an alive branch :-/ tnx
Dear Maciek; :-) due the type if our attachments which are JPEG files, don't hope compression to help me more! but I serious to test it ASAP. it seems pretty to be able to compress Emails body on side DB engine. tnx On Wed, Oct 10, 2012 at 11:13 PM, Maciej Dobrzanski < [email protected]> wrote: > Ali,**** > > * * > > Other than modifying RT itself to store attachments outside of the main > database, you could also try InnoDB compression first. It is available in > all recent MySQL versions (5.1, 5.5, 5.6) and it is completely transparent > to queries or applications. Even with some number of larger attachments, > there is always still a lot of plain text in this table (e-mails, > comments), i.e. all the kind of data that should compress very well. You > might be able to reduce the physical table size by 50% or even more this > way (the compression level is actually tunable to some extent, at the > expense of performance of course).**** > > ** ** > > Best regards,**** > > Maciek**** > > ** ** > > MySQL Consulting Services**** > > PSCE | http://www.psce.com/**** > > > -------- > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > http://bestpractical.com/training > > We're hiring! http://bestpractical.com/jobs > > -- Regards, Ali R. Taleghani
-------- Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
