Difference between revisions of "Maintenance ETL"
| Line 17: | Line 17: | ||
==Import Content== | ==Import Content== | ||
| − | This will navigate the given [TPIF] file and import any file contents that may have been in there. | + | This will navigate the given [[TPIF]] file and import any file contents that may have been in there. |
It will only import content that doesn't already exist in the database. | It will only import content that doesn't already exist in the database. | ||
If any content has been imported, a message will be sent to reindex the media. | If any content has been imported, a message will be sent to reindex the media. | ||
Revision as of 14:53, 25 July 2022
The Maintenance ETL is tasked with performing long running tasks. These tasks can take a significant amount of time and cause the Analyst Desktop to become unresponsive.
Tasks Performed
Maintenance is responsible for the following tasks.
Clean Database
When Maintenance cleans a database, it will determine if there are any records in the following tables that do not belong to any media or file. These records are considered to be orphaned.
Delete Media
This will delete the records in the database associated with the given media.
Optimize
As SQL databases grow over time, the query planner may be using stale statistics for optimization. This task will update the statistics on all tables in the database.
Import Content
This will navigate the given TPIF file and import any file contents that may have been in there. It will only import content that doesn't already exist in the database. If any content has been imported, a message will be sent to reindex the media.
