Problem: Adding courses takes up to 10 seconds
Index: rbac_templates: ('rol_id', 'parent')
Officially released with: 4.0.2

Problem: Showing the personal desktop needs much more time with enabled calendar
Index: cal_categories: ('obj_id')
Officially released with: 4.0.0

Problem: Low performance when navigating inside course objects (observed at Hochschule Luzern)
Index: crs_items: ('obj_id')
Officially released with: 4.0.2

Problem: Removing objects from system takes a long time (observed at Hochschule Luzern)
Index: desktop_item: ('item_id')
Officially released with: 4.0.2

Problem: Removing objects from system takes a long time (observed at Hochschule Luzern)
Index: rbac_pa ('ref_id')
Officially released with: 3.10

Problem: Creating of new entries in a media cast takes a long time (observed at Hochschule Luzern)
Alter field: il_meta_format: ('format') from "text" to "varchar(255)".
Index: il_meta_format: ('format')
Officially released with: 4.0

Problem: High System Load with big table mail (observed at University of Cologne)
Index: Table: mail_obj_data ; Fields: user_id and m_type
Officially released with: 4.1

Problem: Long duration creating and searching objects via SOAP (observed at University of Cologne)
Index: Table: obj_data ; Index-Name: 'import_idx'; Field: import_id
Officially released with: 4.21

Problem: User log in via LDAP authentication (observed at University of Cologne)
Index: Table: usr_data ; Index-Name: 'ext_idx'; Fields: ext_account and auth_mode
Officially released with: 4.21

Problem: slow query/improvement (observed at University of Cologne)
Index: Table: event ; Index-Name: 'objid_idx'; Field: obj_id
Officially released with: 4.21

Problem: slow query/improvement (observed at University of Cologne)
Index: Table: conditions; Index-Name: 't_objid_idx'; Field: target_obj_id
Officially released with: 4.21

Problem: slow query/improvement (observed at University of Cologne)
Index: Table: mob_usage; Index-Name: 'uid_idx'; Field: usage_id
Officially released with: 4.21

Problem: slow query/improvement (observed at University of Cologne)
Index: Table: lo_access; Index-Name: 'uid_idx'; Field: usr_id
Officially released with: 4.21

Problem: slow query/improvement (observed at University of Cologne)
Index: Table: cal_categories; Index-Name: 'typeid_idx'; Field: type
Officially released with: 4.21

Problem: slow query/improvement (observed at University of Cologne)
Index: Table: tree; Index-Name: 'lft_idx'; Field: lft
Officially released with: 4.21