Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 19:38e23471d132
more visibility on the index creation
author | am@osimis.io |
---|---|
date | Tue, 10 Jul 2018 11:05:37 +0200 |
parents | dfc7002add9c |
children | aacb651833f5 |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PostgreSQLIndex.cpp Tue Jul 10 07:15:13 2018 +0200 +++ b/PostgreSQL/Plugins/PostgreSQLIndex.cpp Tue Jul 10 11:05:37 2018 +0200 @@ -129,12 +129,13 @@ **/ try { - LOG(INFO) << "Trying to enable trigram matching on the PostgreSQL database to speed up wildcard searches. This may take several minutes"; // we've observed 9 minutes on DB with 100000 studies + LOG(WARNING) << "Trying to enable trigram matching on the PostgreSQL database to speed up wildcard searches. This may take several minutes"; // we've observed 9 minutes on DB with 100000 studies db->Execute( "CREATE EXTENSION pg_trgm; " "CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers USING gin(value gin_trgm_ops);"); SetGlobalIntegerProperty(*db, t, Orthanc::GlobalProperty_HasTrigramIndex, 1); + LOG(WARNING) << "Trigram index has been created"; } catch (Orthanc::OrthancException&) {