search

OHDSI / CohortDiagnostics

An R package for performing various cohort diagnostics.
https://ohdsi.github.io/CohortDiagnostics
41 stars 49 forks source link

Simple removal function for single database result set from Diagnostics Explorer database #840

Open azimov opened 2 years ago

azimov commented 2 years ago

A function should be exported with the following pattern:

removeResultsByDatabaseId <- function(connectionDetails, databaseIds, resultsDatabaseSchema) {

    ... Delete all records from database matching specified ids
}

This should allow simple data refreshes (e.g. if data has been corrupted or a new version of the same data is to be added.

gowthamrao commented 2 years ago

Do you know if we have a standardized process for database optimizations when we do large deletes/inserts. e.g. some db like the statistics/vaccum etc.

Is there experience among the HADES developers on this topic?