Orthanc takes long time to return list of studies

Google Groups archive
1

Hi authors,

I observed that Orthanc (with PostgresSSQLIndex enabled) took very long time (~ 2 minutes) to return list of studies. I use this API for getting studies : localhost/8042/studies?since=0&limit=100.
My Orthanc has ~5 millions of instances and ~130.000 of studies
Here is the statistics of orthanc (via api localhost:8042/statistics)

{ “CountInstances” : 5263383, “CountPatients” : 48799, “CountSeries” : 206031, “CountStudies” : 130605, “TotalDiskSize” : “4487611508380”, “TotalDiskSizeMB” : 4279719, “TotalUncompressedSize” : “4487611508380”, “TotalUncompressedSizeMB” : 4279719 }

aabc.png
My question is that is there any API for getting studies faster ? I dont think verbose log can show the statistics of this api , so I dont attach it here.

2

Hi Christopher,

No, there’s no faster way to list the studies.

For such large databases, make sure to use a DB server, e.g Postgres, instead of SQLite.

Best regards,

Alain

abc.png

3

Hello,

A call to “/studies” should run quickly on Orthanc 1.9.7 (the latest version at the time of writing), even with 100k studies, especially if you use “limit=100”.

Make sure to carefully follow the guidelines for best scalability of Orthanc:

https://book.orthanc-server.com/faq/scalability.html

Sébastien-

4

Thanks Sebatien,
Yes I am using orthanc version 1.9.7 (contained in docker) with Indexer Plugin and using PostgreSQL index plugin. I am surprised too.