Menu ▾ ▴

#387 Improve Tag Editor performance

Approved
closed
Ahasuerus
Editor Interface (108)
5
2013-05-27
2012-12-30
Ahasuerus
No

The Tag Editor takes up to a few seconds to display the list of "Most Popular Tags in the Database". This is due to the fact that the list is compiled by examining all tags in the database. As the number of tags goes up over time, it will take longer and longer to compile this list.

Discussion

  • Ahasuerus

    Ahasuerus - 2012-12-30
    • summary: Improve tag performace --> Improve Tag Editor performace
     

  • Ahasuerus

    Ahasuerus - 2013-05-27
    • summary: Improve Tag Editor performace --> Improve Tag Editor performance
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1 +1 @@
-The Tag Editor takes up to a few seconds to display the list of "Most Popular Tags in the Database". This is due to the fact that the list is compiled by examining all tags in the database. As the number of tags goes up over time, it will take longer and longer to compile this list. It would be better to compile the list once per day, presumably overnight, and then use it for the next 24 hours, which should make it appear instantaneously.
+The Tag Editor takes up to a few seconds to display the list of "Most Popular Tags in the Database". This is due to the fact that the list is compiled by examining all tags in the database. As the number of tags goes up over time, it will take longer and longer to compile this list.
    • status: open --> closed
    • assigned_to: Ahasuerus
    • Group: --> Approved
     

  • Ahasuerus

    Ahasuerus - 2013-05-27

    The underlying SQL query was rewritten to use the IN clause in edit/edittags.py 1.10, which resulted in near-instantenous retrieval of the tag list. Installed in r2013-85.

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB