Mercurial > hg > orthanc-databases
view MySQL/Plugins/MySQLIndex.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" #include "../../Framework/MySQL/MySQLParameters.h" namespace OrthancDatabases { class MySQLIndex : public IndexBackend { private: MySQLParameters parameters_; bool clearAll_; protected: virtual bool HasChildCountTable() const { return false; } public: MySQLIndex(OrthancPluginContext* context, const MySQLParameters& parameters, bool readOnly); void SetClearAll(bool clear) { clearAll_ = clear; } virtual IDatabaseFactory* CreateDatabaseFactory() ORTHANC_OVERRIDE; virtual void ConfigureDatabase(DatabaseManager& database, bool hasIdentifierTags, const std::list<IdentifierTag>& identifierTags) ORTHANC_OVERRIDE; virtual bool HasRevisionsSupport() const ORTHANC_OVERRIDE { return false; // TODO - REVISIONS } 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 int64_t GetLastChangeIndex(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 // New primitive since Orthanc 1.12.0 virtual bool HasLabelsSupport() const ORTHANC_OVERRIDE { return true; } #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 }; }