Believing there is no God means all the suffering in the world isn't caused by an omniscient, omnipotent force that isn't bothered to help or is just testing us, but rather something we all may be responsible for, something we all may be able to help others with in the future. No God means the possibility of less suffering in the future.
All downloads of Slax 6.x from the download page were always secretly counted, but it was only several weeks ago when I realized that it could be interesting to publish the counter under the download links for the general audience. The counter stated something around 1800000 downloads at that time. Today I've just realized that the counter is far beyond 2 millions!
Thank you everybody who download Slax! Especially all the people from United States (16%), Russia (7%), Poland (5%), Germany (5%), Italy (4%), Czech Republic (4%), France (3%) and United Kingdom (3%). 23 comments
Just few days ago, Phillip Lougher added the long awaited LZMA decompression to his squashfs tree (here are the patches).
I'm not sure what kernel version will incorporate these changes. I guess 2.6.32 is in the -rc state already so we will have to wait for the next one. 8 comments
From time to time, I need to select a random row from MySQL table. The official documentation suggests SELECT * FROM table1 ORDER BY RAND() LIMIT 1, but this is very dangerous. It can take ages to select a random row from a table with millions of records. The reason can be noticed after running the same query with 'EXPLAIN' keyword at the beginning: Using temporary; Using filesort. It's the worst situation which could happen.
I'm always looking for as best optimalization as possible, so I had to come up with something faster. And here is the result:
SELECT @r:=RAND(); SELECT @i:= (SELECT MIN(id) FROM table1 WHERE id>= (SELECT (@r*(SELECT MAX(id) FROM table1)))); SELECT * FROM table1 WHERE id=@i;
As you can see, there are 3 queries needed instead of one, but the time to find out the particular random row is reduced to the smallest possible value, because there is no more needed to create any temporary tables or sort them. After EXPLAINing the queries again, ... more5 comments
In the last few days, Phillip Lougher (squashfs author) published several patches, which is a very important step towards the new lzma support. In short, the patches move the decompressing functions to a separated file, and replace the zlib_uncompress() call by squashfs_decompress(). This is exactly what had to happen in order to provide a decompressor framework for Squashfs, 'allowing multiple decompressors to be easily supported'.
Since it (lzma) is already in kernel for some time, I think that we should see LZMA support in squashfs very soon. 12 comments