在实现了系数矩阵的三角分解后,为了避免“小主元”做除数而导致更大的误差,在doolittle分解的同时,每一步先选主元,再进行分解计算。-achieved in the triangular matrix decomposition, in order to avoid "small PCA" do Divisor and lead to greater error, the Doolittle decomposition at the same time, every step the first choice PCA, further decomposition.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001735s ]
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.089705s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001942s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001267s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001086s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003786s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000942s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004178s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018643s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001373s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 219993 [ RunTime:0.018202s ]