# HG changeset patch
# User Sebastien Jodogne <s.jodogne@gmail.com>
# Date 1618587911 -7200
# Node ID 9856290c3cfdb36953f07e3a578d3379e685929c
# Parent  316f7b981e943f84980b3c15b3c9c86524cd3b3d
todo

diff -r 316f7b981e94 -r 9856290c3cfd TODO
--- a/TODO	Fri Apr 16 17:20:37 2021 +0200
+++ b/TODO	Fri Apr 16 17:45:11 2021 +0200
@@ -9,6 +9,10 @@
 
 * Store revisions for metadata and attachments in PostgreSQL and MySQL
 
+* Performance of joins in LookupResources: Create cached statement for
+  LookupResources, that are grouped to search up to, say, 10 tags,
+  instead of recompiling for each request
+
 
 ---------------------
 Common - Storage area
@@ -25,3 +29,10 @@
 
 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
   https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
+
+* Add index to speed up wildcard search, as already done in PostgreSQL:
+
+  - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html +
+    ALTER TABLE table ADD FULLTEXT index_name(column1);
+
+  - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html