RFID复杂事件处理系统的研究实验，性能上做优化用公共子表达式，限制条件变换等方面-RFID complex event processing system for experiments done to optimize performance using common subexpression, restrictions, etc. Transform
文 件 列 表
experiment6 test .classpath .project experiment5 test .classpath .project experiment4 test2 test1 .classpath .project experiment3 test .classpath .project experiment2 test .classpath .project experiment1 test .classpath .project experiment7 test2 test1 .classpath .project
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002156s ]
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.094452s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.003016s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002212s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002315s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003653s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002095s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003262s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014878s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002492s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 317147 [ RunTime:0.001318s ]
