Orthanc date search

Hi,

We have been working with Orthanc for more than 2 years (with Postgres and all suggestions to speed up). One thing I noticed is that it is getting really slow when we search by date, but if we search by Accession Number, Patient Name or Patient ID works instantly.

How Orthanc makes a date search? Maybe it is missing a database index for dates?

Thanks!

Best regards,

Tomas

Hello,

The “StudyDate” (0008,0020) tag is indexed, just like “Accession Number”, “Patient Name” and “Patient ID”.

Your C-FIND SCU most probably asks Orthanc for another tag that is not indexed.

Run Orthanc in “–verbose” mode in order to inspect the full C-FIND request that is received by Orthanc:
https://book.orthanc-server.com/faq/log.html

HTH,
Sébastien-