ILIAS Logo
ILIAS Information Center
You are not logged in.   Login   Register   

Main Menu

Icon WikiPerformance Wiki

Information about performance tuning for bigger installations
Change Notification: Activate for Wiki | Activate for Page

Performance Improvements through Table Indices

Additional Indices that improve 3.10

Please note that you need to remove any indices that you have added manually, before you update to the ILIAS version that will include the index itself. See the list below.
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

Inofficial additional Indices which improve ILIAS 4:

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: not yet
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: not yet
Problem: slow query/improvement (observed at University of Cologne)
Index: Table: event ; Index-Name: 'objid_idx'; Field: obj_id
Officially released with: not yet
Problem: slow query/improvement (observed at University of Cologne)
Index: Table: conditions; Index-Name: 't_objid_idx'; Field: target_obj_id
Officially released with: not yet
Problem: slow query/improvement (observed at University of Cologne)
Index: Table: mob_usage; Index-Name: 'uid_idx'; Field: usage_id
Officially released with: not yet
Problem: slow query/improvement (observed at University of Cologne)
Index: Table: lo_access; Index-Name: 'uid_idx'; Field: usr_id
Officially released with: not yet
Problem: slow query/improvement (observed at University of Cologne)
Index: Table: cal_categories; Index-Name: 'typeid_idx'; Field: type
Officially released with: not yet
Problem: slow query/improvement (observed at University of Cologne)
Index: Table: tree; Index-Name: 'lft_idx'; Field: lft
Officially released with: not yet


Icon Public Comments

Public Comments


Wiki Search (Block)