annotate TODO @ 367:d04fd259215b

missing integration OrthancOdbc-1.1->default
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 05 Dec 2022 14:20:51 +0100
parents 7671fa7f099e
children c1fe28de1bf6
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
2 ==============================
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
3 == Orthanc database plugins ==
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
4 ==============================
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
6 -----------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
7 Common - Database index
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
8 -----------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
9
258
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
10 * Performance of joins in LookupResources: Create cached statement for
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
11 LookupResources, that are grouped to search up to, say, 10 tags,
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
12 instead of recompiling for each request
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
13
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
14
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
15 ---------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
16 Common - Storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
17 ---------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
18
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
19 * Implement the "StoreDicom" option from the default filesystem
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
20 storage area to run MySQL/PostgreSQL storage in index-only mode:
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
21 https://book.orthanc-server.com/contributing.html
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
22
259
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 258
diff changeset
23 * Performance: Add a pool of connections to PostgreSQL/MySQL, as
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 258
diff changeset
24 already done in the database index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 258
diff changeset
25
360
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
26 ----------
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
27 PostgreSQL
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
28 ----------
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
29
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
30 * reported issue to validate: uploading lots of files through HTTP with:
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
31 - 1 client and IndexConnectionsCount==1 took 100s
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
32 - 2 client and IndexConnectionsCount==2 took 600s (lots of transaction replayed)
Alain Mazy <am@osimis.io>
parents: 266
diff changeset
33
365
Alain Mazy <am@osimis.io>
parents: 364
diff changeset
34 * Seems Orthanc might deadlock when there are plenty of conflicting transactions:
Alain Mazy <am@osimis.io>
parents: 364
diff changeset
35 https://groups.google.com/g/orthanc-users/c/xQelEcKqL9U/m/HsvxwlkvAQAJ
Alain Mazy <am@osimis.io>
parents: 364
diff changeset
36 https://groups.google.com/g/orthanc-users/c/1bkClfZ0KBA/m/s4AlwVh3CQAJ
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
37
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
38 -----
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
39 MySQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
40 -----
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
41
266
cc7af42d4f23 Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 259
diff changeset
42 * Store revisions for metadata and attachments in MySQL (this is
cc7af42d4f23 Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 259
diff changeset
43 already implemented in PostgreSQL)
cc7af42d4f23 Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 259
diff changeset
44
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
45 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
46 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
258
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
47
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
48 * Add index to speed up wildcard search, as already done in PostgreSQL:
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
49
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
50 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html +
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
51 ALTER TABLE table ADD FULLTEXT index_name(column1);
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
52
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
53 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html