Bug 49748 – appcenter schema attributes not indexed

Bug 49748 - appcenter schema attributes not indexed


Summary:	appcenter schema attributes not indexed

Status:	NEW

Product:	UCS
Classification:	Unclassified
Component:	App Center
Version:	UCS 4.4
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	---
Assigned To:	App Center maintainers
QA Contact:	App Center maintainers

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2019-06-28 12:00 CEST by Felix Botner
Modified:	2023-07-12 18:25 CEST (History)
CC List:	3 users (show)

See Also:	53709
What kind of report is it?:	Development Internal
What type of bug is this?:	---
Who will be affected by this bug?:	---
How will those affected feel about the bug?:	---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):	Large environments
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Felix Botner

2019-06-28 12:00:46 CEST

The App Center creates schema extension for apps. But these attributes are not added to the index.

Jun 28 00:08:03 master slapd[11169]: <= mdb_equality_candidates: (ownCloudEnabled) not indexed

Comment 1 Dirk Ahrnke

2021-01-18 17:51:09 CET

It is known that missing indexes will lead to decreased performance especially when being queried frequently. This is definitely the case for ownCloud and Nextcloud.

Comment 2 Daniel Tröder

2021-12-02 11:22:44 CET

Maintaining indices is expensive. It may not be clear if for example equality or substring indices are needed. If the wrong ones are created, then the performance loss does not only happen during reads but also (without gaining anything) during writes.
For a generalized solution the indexing should be configurable.