在学习数据结构时,往往不知道那些结构与算法有何用,以及怎么用。这个小小程序充分显示了Huffman二叉树的应用。虽然其压缩效果比RAR相差甚远,但也能说明一二。
-the study data structure, they often do not know what the structure and algorithm, as well as how use. This little procedure fully demonstrated the application of the binary tree Huffman. Although the compression ratio falls far short of RAR, but can also explain on January 2.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001118s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.070618s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001025s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001142s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000992s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003021s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000864s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003739s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015987s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001444s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 165562 [ RunTime:0.014413s ]