在Android设备上执行时,SQLite cursor.getCount()是否昂贵?
哪个更快:
Cursor cursor = db.rawQuery(sql, null);
int length = cursor.getCount();
final List items = new ArrayList(length * 2); // need maybe 2 items per row
if (cursor.moveToFirst()) {
// loop trough the query result
do {
...
要么
Cursor cursor = db.rawQuery(sql, null);
final List items = new ArrayList(); // capacity is 0 by default on android
if (cursor.moveToFirst()) {
// loop trough the query result
do {