Mercurial > hg > orthanc-databases
view PostgreSQL/Plugins/PostgreSQLIndex.h @ 595:272eeb046a88 find-refactoring
Introduced a new ChildCount table in PG to improve retrieval of NumberOfRelatedStudyInstances and other similar tags that could consume up to 95% of a request time + added a DB-Housekeeper thread to populate the new table
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Tue, 26 Nov 2024 17:59:14 +0100 |
parents | 47b14499455e |
children | 8f6e7ae942f3 |
line wrap: on
line source
/** * Orthanc - A Lightweight, RESTful DICOM Store * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics * Department, University Hospital of Liege, Belgium * Copyright (C) 2017-2023 Osimis S.A., Belgium * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium * * This program is free software: you can redistribute it and/or * modify it under the terms of the GNU Affero General Public License * as published by the Free Software Foundation, either version 3 of * the License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, but * WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. **/ #pragma once #include "../../Framework/Plugins/IndexBackend.h" #include "../../Framework/PostgreSQL/PostgreSQLParameters.h" #include <boost/thread.hpp> namespace OrthancDatabases { class PostgreSQLIndex : public IndexBackend { private: PostgreSQLParameters parameters_; bool clearAll_; std::unique_ptr<boost::thread> dbHousekeeper_; bool housekeeperShouldStop_; protected: virtual void ClearDeletedFiles(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual void ClearDeletedResources(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual void ClearRemainingAncestor(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual bool HasChildCountTable() const ORTHANC_OVERRIDE { return true; } void ApplyPrepareIndex(DatabaseManager::Transaction& t, DatabaseManager& manager); void StartDbHousekeeper(DatabaseManager& manager); static void WorkerHousekeeper(bool& housekeeperShouldStop, DatabaseManager* manager); public: PostgreSQLIndex(OrthancPluginContext* context, const PostgreSQLParameters& parameters, bool readOnly = false); void SetClearAll(bool clear) { clearAll_ = clear; } virtual IDatabaseFactory* CreateDatabaseFactory() ORTHANC_OVERRIDE; virtual void ConfigureDatabase(DatabaseManager& manager, bool hasIdentifierTags, const std::list<IdentifierTag>& identifierTags) ORTHANC_OVERRIDE; virtual bool HasRevisionsSupport() const ORTHANC_OVERRIDE { return true; } virtual int64_t CreateResource(DatabaseManager& manager, const char* publicId, OrthancPluginResourceType type) ORTHANC_OVERRIDE; virtual void DeleteResource(IDatabaseBackendOutput& output, DatabaseManager& manager, int64_t id) ORTHANC_OVERRIDE; virtual void SetResourcesContent(DatabaseManager& manager, uint32_t countIdentifierTags, const OrthancPluginResourcesContentTags* identifierTags, uint32_t countMainDicomTags, const OrthancPluginResourcesContentTags* mainDicomTags, uint32_t countMetadata, const OrthancPluginResourcesContentMetadata* metadata) ORTHANC_OVERRIDE; virtual uint64_t GetTotalCompressedSize(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual uint64_t GetTotalUncompressedSize(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual bool HasCreateInstance() const ORTHANC_OVERRIDE { return true; } #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1 virtual void CreateInstance(OrthancPluginCreateInstanceResult& result, DatabaseManager& manager, const char* hashPatient, const char* hashStudy, const char* hashSeries, const char* hashInstance) ORTHANC_OVERRIDE; #endif virtual uint64_t GetResourcesCount(DatabaseManager& manager, OrthancPluginResourceType resourceType) ORTHANC_OVERRIDE; virtual int64_t GetLastChangeIndex(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual void TagMostRecentPatient(DatabaseManager& manager, int64_t patient) ORTHANC_OVERRIDE; // New primitive since Orthanc 1.12.0 virtual bool HasLabelsSupport() const ORTHANC_OVERRIDE { return true; } virtual bool HasAtomicIncrementGlobalProperty() ORTHANC_OVERRIDE { return true; } virtual int64_t IncrementGlobalProperty(DatabaseManager& manager, const char* serverIdentifier, int32_t property, int64_t increment) ORTHANC_OVERRIDE; virtual bool HasUpdateAndGetStatistics() ORTHANC_OVERRIDE { return true; } virtual void UpdateAndGetStatistics(DatabaseManager& manager, int64_t& patientsCount, int64_t& studiesCount, int64_t& seriesCount, int64_t& instancesCount, int64_t& compressedSize, int64_t& uncompressedSize) ORTHANC_OVERRIDE; virtual void Shutdown() ORTHANC_OVERRIDE; // #if ORTHANC_PLUGINS_VERSION_IS_ABOVE(1, 12, 5) // virtual bool HasFindSupport() const ORTHANC_OVERRIDE; // #endif // #if ORTHANC_PLUGINS_VERSION_IS_ABOVE(1, 12, 5) // virtual void ExecuteFind(Orthanc::DatabasePluginMessages::TransactionResponse& response, // DatabaseManager& manager, // const Orthanc::DatabasePluginMessages::Find_Request& request) ORTHANC_OVERRIDE; // #endif }; }