Skip to content

Improve Internal Database Index Structure #2028

@alexanderkiel

Description

@alexanderkiel

Currently we use hashing for values in the SearchParamValueResource, ResourceSearchParamValue and CompartmentSearchParamValueResource indices. As this works well for terminology such as a reasonable number of codings, it doesn't work for identifiers.

We have to remove the value hashing and create separate tables for system URLs because they are just too long.

In the meanwhile, four work rounds are implemented right now:

Sub-issues

Metadata

Metadata

Assignees

Labels

epicA large body of work that can be broken down into a number of smaller issues.module:dbperformancePerformance improvement

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions