Menu ▾ ▴

#895 Improve search performance

Approved
closed
Ahasuerus
None
5
2016-05-29
2016-05-29
Ahasuerus
No

Disable single character searches in regular Search for names, all titles, fiction titles and publishers. They can cause performance problems. In addition, a search on _ can cause a MySQL error because the amount of data returned by the database exceeds the default package size used by MySQL. Also change the way transliterated names are searched to improve performace: use UNION instead of OR in SQL statements .

Discussion

  • Ahasuerus

    Ahasuerus - 2016-05-29
    • summary: Disable single character searches --> Improve search performance
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1 +1 @@
-Disable single character searches in regular Search. They can cause performance problems. In addition, a search on _ can cause a MySQL error because the amount of data returned by the database exceeds the default package size used by MySQL.
+Disable single character searches in regular Search for names, all titles, fiction titles and publishers. They can cause performance problems. In addition, a search on _ can cause a MySQL error because the amount of data returned by the database exceeds the default package size used by MySQL. Also change the way transliterated names are searched to improve performace: use UNION instead of OR in SQL statements .
     

  • Ahasuerus

    Ahasuerus - 2016-05-29
    • status: open --> closed
     

  • Ahasuerus

    Ahasuerus - 2016-05-29

    Implemented in:

    biblio/se.py 1.49
common/SQLparsing.py 1.176

    Installed in r2016-089 on 2016-05-29. Closing.

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB