Sorting algorithms.
"För att underlätta testningen skall man via en
”meny” få välja algoritm, antal poster och vilken sorts vektor (slumpad, omvänd eller
nästan ordnad) då programmet startas. Om antalet poster är färre än 1000 skall
vektorn skrivas ut till skärmen både före och efter sorteringen, är antalet poster fler än
1000 skall ingen dylik utskrift göras."
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001228s ]
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.088418s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001170s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001891s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001121s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003582s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000954s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003241s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014202s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001204s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 275317 [ RunTime:0.001233s ]