Hi
Mac on
ORTHANC 1.5.4 + Postgres11
Can I create an index or view to speed up a date range search to Postgres?
Hi
Mac on
ORTHANC 1.5.4 + Postgres11
Can I create an index or view to speed up a date range search to Postgres?
Hello,
Make sure that you use the latest version of Orthanc (at the time of writing, 1.5.7) together with the latest version of the PostgreSQL plugin (3.2 for now).
Range queries over “StudyDate” are already using an index.