view TODO @ 362:a39038c4094a

missing integration OrthancOdbc-1.1->mainline
author Sebastien Jodogne <s.jodogne@gmail.com>
date Sun, 05 Jun 2022 14:27:59 +0200
parents 1d57fac91104
children c34510606a18
line wrap: on
line source


==============================
== Orthanc database plugins ==
==============================

-----------------------
Common - Database index
-----------------------

* 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
---------------------

* Implement the "StoreDicom" option from the default filesystem
  storage area to run MySQL/PostgreSQL storage in index-only mode:
  https://book.orthanc-server.com/contributing.html

* Performance: Add a pool of connections to PostgreSQL/MySQL, as
  already done in the database index plugins

----------
PostgreSQL
----------

* reported issue to validate:  uploading lots of files through HTTP with:
  - 1 client and IndexConnectionsCount==1 took 100s
  - 2 client and IndexConnectionsCount==2 took 600s (lots of transaction replayed)


-----
MySQL
-----

* Store revisions for metadata and attachments in MySQL (this is
  already implemented in PostgreSQL)

* 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