查询表中每天插入的数量,可以分析每天数据量,然后对代码优化。
// cloumnTime 时间值字段
StringBuffer sbfQuery = new StringBuffer("");
try {
Cursor cursor = sqLite.rawQuery("select date(" + cloumnTime + ") as day, count(*) as " +
"insert_count from " + tableName + " group by date(" + cloumnTime + ")", null);
while (cursor.moveToNext()) {
String day = cursor.getString(cursor.getColumnIndex("day"));
int insertCount = cursor.getInt(cursor.getColumnIndex("insert_count"));
sbfQuery.append(day).append("\t").append(insertCount).append("\n");
}
}catch (SQLException sqlE) {
sqlE.printStackTrace();
}
return sbfQuery.toString();