diff options
author | Marc Cousin <marc.cousin@people-doc.com> | 2020-02-24 16:03:08 +0100 |
---|---|---|
committer | Marc Cousin <marc.cousin@people-doc.com> | 2020-02-24 16:07:47 +0100 |
commit | 7121e559c544154af2393e083b05add9dad4b061 (patch) | |
tree | 1af6ea5d4289e585840f3c3c823209250ed79ce8 | |
parent | c8fce0f321805d13193846f66b847a3ea44e7d31 (diff) |
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>
-rw-r--r-- | appinfo/database.xml | 33 |
1 files 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> |