Change codes for performance

[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_private.c

diff --git a/src/pkgmgrinfo_private.c b/src/pkgmgrinfo_private.c
index b7809f8..21b4840 100644 (file)
--- a/src/pkgmgrinfo_private.c
+++ b/src/pkgmgrinfo_private.c
@@ -394,14 +394,12 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
                break;
        case E_PMINFO_APPINFO_PROP_APP_DISABLE:
                if (strcasecmp(node->value, "true") == 0)
-                       snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE OR "
-                                       "ai.app_id IN (SELECT app_id FROM package_app_info_for_uid "
-                                       "WHERE uid=%d AND is_disabled='true'))", uid);
+                       snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
+                                       "OR ui.is_disabled='true' COLLATE NOCASE)");
                else
-                       snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE AND "
-                                       "ai.app_id NOT IN (SELECT app_id FROM package_app_info_for_uid "
-                                       "WHERE uid=%d AND is_disabled='true'))", uid);
-               flag = E_PMINFO_APPINFO_JOIN_APPINFO_FOR_UID;
+                       snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
+                                       "AND (ui.is_disabled='false' COLLATE NOCASE " \
+                                       "OR ui.is_disabled IS NULL))");
                break;
        case E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE:
                snprintf(buf, MAX_QUERY_LEN, "ai.app_support_disable=? COLLATE NOCASE");