From 55b23e316f9644f45cf5ae43729e88031ce337ee Mon Sep 17 00:00:00 2001 From: Oguz Kocer Date: Wed, 25 May 2016 13:45:22 +0300 Subject: Improve the sql query in deletePeopleForLocalBlogIdExceptForFirstPage --- .../main/java/org/wordpress/android/datasets/PeopleTable.java | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) (limited to 'WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java') diff --git a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java index d9221ad92..822b28146 100644 --- a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java +++ b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java @@ -99,9 +99,14 @@ public class PeopleTable { int fetchLimit = PeopleUtils.FETCH_USERS_LIMIT; if (size > fetchLimit) { int deleteCount = size - fetchLimit; - String[] args = new String[]{Integer.toString(deleteCount), Integer.toString(localTableBlogId)}; - getWritableDb().delete(PEOPLE_TABLE, "person_id " + - "IN (SELECT person_id FROM people ORDER BY display_name DESC LIMIT ?) AND local_blog_id=?", args); + String[] args = new String[] { + Integer.toString(localTableBlogId), + Integer.toString(localTableBlogId), + Integer.toString(deleteCount) + }; + getWritableDb().delete(PEOPLE_TABLE, "local_blog_id=? AND person_id " + + "IN (SELECT person_id FROM " + PEOPLE_TABLE + " WHERE local_blog_id=? " + + "ORDER BY display_name DESC LIMIT ?)", args); } } -- cgit v1.2.3