aboutsummaryrefslogtreecommitdiffstats
path: root/OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java
diff options
context:
space:
mode:
authorVincent Breitmoser <valodim@mugenguild.com>2015-11-15 02:45:21 +0100
committerVincent Breitmoser <valodim@mugenguild.com>2015-11-15 03:08:31 +0100
commitabfa7d743cf159a25f54ddcdc84d375c7a9df21e (patch)
treeafeaff49e174ac8700fc7893eeaeb442714cb0f8 /OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java
parent0456caedf43b2903731a669690333b07f217b8c6 (diff)
downloadopen-keychain-abfa7d743cf159a25f54ddcdc84d375c7a9df21e.tar.gz
open-keychain-abfa7d743cf159a25f54ddcdc84d375c7a9df21e.tar.bz2
open-keychain-abfa7d743cf159a25f54ddcdc84d375c7a9df21e.zip
some optimizations and indexes for the main key list query
Diffstat (limited to 'OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java')
-rw-r--r--OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java2
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java b/OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java
index 2735eb6b8..23c1250d0 100644
--- a/OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java
+++ b/OpenKeychain/src/main/java/org/sufficientlysecure/keychain/ui/KeyListFragment.java
@@ -298,7 +298,7 @@ public class KeyListFragment extends LoaderFragment
}
static final String ORDER =
- KeyRings.HAS_ANY_SECRET + " DESC, UPPER(" + KeyRings.USER_ID + ") ASC";
+ KeyRings.HAS_ANY_SECRET + " DESC, " + KeyRings.USER_ID + " COLLATE NOCASE ASC";
@Override
public Loader<Cursor> onCreateLoader(int id, Bundle args) {