Mercurial > hg > orthanc-databases
view Odbc/Plugins/OdbcIndex.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 | 3b1070dcab2f |
children |
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" namespace OrthancDatabases { class OdbcIndex : public IndexBackend { private: unsigned int maxConnectionRetries_; unsigned int connectionRetryInterval_; std::string connectionString_; protected: virtual bool HasChildCountTable() const { return false; } public: OdbcIndex(OrthancPluginContext* context, const std::string& connectionString, bool readOnly); unsigned int GetMaxConnectionRetries() const { return maxConnectionRetries_; } void SetMaxConnectionRetries(unsigned int retries) { maxConnectionRetries_ = retries; } unsigned int GetConnectionRetryInterval() const { return connectionRetryInterval_; } void SetConnectionRetryInterval(unsigned int seconds); 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 LogChange(DatabaseManager& manager, int32_t changeType, int64_t resourceId, OrthancPluginResourceType resourceType, const char* date) ORTHANC_OVERRIDE; virtual int64_t GetLastChangeIndex(DatabaseManager& manager) ORTHANC_OVERRIDE; virtual void DeleteAttachment(IDatabaseBackendOutput& output, DatabaseManager& manager, int64_t id, int32_t attachment) ORTHANC_OVERRIDE; // New primitive since Orthanc 1.12.0 virtual bool HasLabelsSupport() const ORTHANC_OVERRIDE { return false; } #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; // virtual void ExecuteCount(Orthanc::DatabasePluginMessages::TransactionResponse& response, // DatabaseManager& manager, // const Orthanc::DatabasePluginMessages::Find_Request& request) ORTHANC_OVERRIDE; #endif }; }