From 7121e559c544154af2393e083b05add9dad4b061 Mon Sep 17 00:00:00 2001
From: Marc Cousin <marc.cousin@people-doc.com>
Date: Mon, 24 Feb 2020 16:03:08 +0100
Subject: Index improvements

Close #510

Hopefully this will solve performance with MySQL/MariaDB.
There is no way to prove this though. See #510

Signed-off-by: Marc Cousin <marc.cousin@people-doc.com>
---
 appinfo/database.xml | 33 ++++++++++++++++++++++++++++-----
 1 file changed, 28 insertions(+), 5 deletions(-)

diff --git a/appinfo/database.xml b/appinfo/database.xml
index adc8f197a..d210d3f45 100644
--- a/appinfo/database.xml
+++ b/appinfo/database.xml
@@ -402,28 +402,51 @@
             </index>
 
             <index>
-                <name>news_items_feed_id_index</name>
+                <name>news_items_fingerprint_idx</name>
+                <field>
+                    <name>fingerprint</name>
+                </field>
+            </index>
+
+            <index>
+                <name>news_items_item_guid</name>
+                <field>
+                    <name>guid_hash</name>
+                </field>
                 <field>
                     <name>feed_id</name>
                 </field>
             </index>
 
             <index>
-                <name>news_items_fingerprint_idx</name>
+                <name>news_items_unread_feed_id</name>
                 <field>
-                    <name>fingerprint</name>
+                    <name>unread</name>
+                </field>
+                <field>
+                    <name>feed_id</name>
                 </field>
             </index>
 
             <index>
-                <name>news_items_item_guid</name>
+                <name>news_items_starred_feed_id</name>
                 <field>
-                    <name>guid_hash</name>
+                    <name>starred</name>
                 </field>
                 <field>
                     <name>feed_id</name>
                 </field>
             </index>
+
+            <index>
+                <name>news_items_unread_id</name>
+                <field>
+                    <name>unread</name>
+                </field>
+                <field>
+                    <name>id</name>
+                </field>
+            </index>
         </declaration>
     </table>
 </database>
-- 
cgit v1.2.3