diff options
author | Christian Schneppe <christian@pix-art.de> | 2019-05-09 21:47:50 +0200 |
---|---|---|
committer | Christian Schneppe <christian@pix-art.de> | 2019-05-18 00:01:57 +0200 |
commit | 294144943429503f62675d23b9911d43c0f41ce3 (patch) | |
tree | 6ca73458e72a8afe0a148f8971726eeb7311ea71 /src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java | |
parent | 5b75d52d444d6cda368e85f5884163e229451ece (diff) |
performance improvements
Diffstat (limited to 'src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java')
-rw-r--r-- | src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java b/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java index 6fc6d7569..3bf332c92 100644 --- a/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java +++ b/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java @@ -1097,13 +1097,15 @@ public class DatabaseBackend extends SQLiteOpenHelper { } public void expireOldMessages(long timestamp) { + long start = SystemClock.elapsedRealtime(); final String[] args = {String.valueOf(timestamp)}; SQLiteDatabase db = this.getReadableDatabase(); db.beginTransaction(); db.delete("messages_index", "uuid in (select uuid from messages where timeSent<?)", args); - db.delete(Message.TABLENAME, "timeSent<?", args); + int num = db.delete(Message.TABLENAME, "timeSent<?", args); db.setTransactionSuccessful(); db.endTransaction(); + Log.d(Config.LOGTAG, "deleted " + num + " expired messages in " + (SystemClock.elapsedRealtime() - start) + "ms"); } public MamReference getLastMessageReceived(Account account) { |