This sample demonstrates compression capabilities available in the .NET Framework. It builds a Windows Forms application that employs the GZipStream and DeflateStream types to compress and decompress files. The sample also introduces several types that are new in the .NET Framework version 2.0.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001062s ]
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.102877s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001614s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.012502s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002541s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003288s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000919s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003768s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018852s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001797s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 557531 [ RunTime:0.016404s ]
