Mr. ZIP promoted the use of ZIP codes for the USPS during the 1960s and 1970s. (Photo credit: Wikipedia)
Just a quick post about something I just found out: using 7-zip (open source, hence preferred) can be slow. WinRAR has the name to be faster, and co-workers sometimes ask why it is not used instead.
But 7-zip uses multiple compression algorithms. Most of the time, the default algorithm (LZMA) is used. But the option to use the improved LZMA2 has been around for a while. This algorithm has been designed so that it can use multiple cores, whereas LZMA can only use 2 CPU cores effectively. And I have to say: speed increase on “Normal” compression is already 50%. I have not yet checked out the resulting size, but I need a deflation to about 10% of the original file, and that really seems feasible right now (halfway the process).
Maybe you’ve wondered about this, and maybe you already knew this. But if you didn’t yet, I hope I just made your waiting times a bit shorter 🙂
Update: to use the LZMA2-algorithm from the commandline, use the following:
7z a -m0=lzma2 -mmt6 o:\1.7z o:\1.dmp
A colleague of mine, and I were conversing about the benefits of MS-SQL over MySQL. One of them is the SSMS, which makes database management and query programming very easy. Then he pointed me to HeidiSQL – MySQL made easy. And it looks beautiful! Gonna look into that later today.
Update: having browsed their site a bit, it looks like a very nice tool, and might be a good replacement/enhancement for the MySQL Administrator tool. My biggest problem however, is that it’s made in Delphi, and therefore only really works in Windows. I would love to use a great management tool, open source (better yet: Free Software) under GNU/Linux. Anyone have another idea? I still haven’t really decided on a platform to use: both MySQL and PostgreSQL look like pretty nice candidates.