Hi, windows file compression using LZNT1 https://msdn.microsoft.com/en-us/library/jj711990.aspx that is dictionary based compression like LZ4. It is work in 64kB block that compress into smaller are with some free space for update. But any update is problematic and for MSSQL, Hyper-V and more is prohibited.
Firebird compression (old and new) working on record fragment. If packed size of fragment doesn't fit into page, firebird put record into different area of file (internally is more complex including page compacting). With new RLE you will probably receive less compression ratio on windows compression because lot of sequences [-128,0] are eliminated, but I don't recommend windows compression for live servers (only backups are good idea). Slavek > Hi, > > you misunderstood me > i say that i saw benefits when i apply compression to my own db file at > windows system level. > I do not remember numbers exactly - but improvement was significant because > i had on that system low memory compared to db size itself. > Memory like 4GB and db size ~90GB > > I am happy that new algorithm is not only better but also faster and low > memory consumption is needed > But i am interested if it is also good for writing not only reading. > > > regards, > Karol Bieniaszewski > > > > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming The Go Parallel Website, sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for all > things parallel software development, from weekly thought leadership blogs to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
