只要有任务做,就可以快速进步,最近接手的一个任务是对各类业务数据进行定时统计,数据量比较庞大,要求短时间内出统计结果。完成任务的过程中,学习到如下知识:
SELECT userid
FROM ${tableName}
LIMIT #{start}, #{pageSize}
ExecutorService pool = Executors.newFixedThreadPool(80);
for (int dbIndex = 0; dbIndex < 11; dbIndex++) {
for (int tableIndex = 0; tableIndex < 11; tableIndex++) {
DealUidRunnable thread = new DealUidRunnable(dbIndex, tableIndex);
pool.execute(thread);
}
}
pool.shutdown();
try {
pool.awaitTermination(2, TimeUnit.HOURS);
} catch (InterruptedException e) {
logger.error("error:", e);
}