Ticket #87 (closed enhancement: wontfix)
Database compression
| Reported by: | looki | Owned by: | ofer |
|---|---|---|---|
| Priority: | major | Milestone: | 0.5 - Beta wordpress plugin |
| Component: | WordPress Plugin | Version: | 0.4.1 |
| Keywords: | Cc: |
Description
Would be interesting to have support to compress the database of translated pages, there is available the Gzip translation on PHP.
In case of anyone use 52 translation pairs in a big site, it will use a large amount of space, so, it will be interesting to have the compression support.
Change History
comment:2 Changed 2 years ago by looki
What you need to do to develop it to be capable of compressing the mysql tables DB?
comment:3 Changed 14 months ago by ofer
- Status changed from new to closed
- Resolution set to wontfix
After further research into this, I don't see how this can be implemented in a useful way, if anyone has better information (links to source examples, or articles) feel free to reopen this ticket.
comment:4 Changed 14 months ago by looki
What type information do you need?
Well, today I know that LZMA2 have the best compression rate for a good performance... and it could be used in a interesting way...
comment:5 Changed 14 months ago by ofer
The information will be a good article regarding DB compression performance, including some tests and comparison numbers, losing even 100MB of storage thanks to DB compression might not be worth the effort, as this will increase page load times and strain on the CPU
gzipping the segments is not too spiffy, as those are too short for any real gains
using a compressed table on mysql might do, but this has probably never came of age