Main Menu

Using ILIAS
Home
Using ILIAS Download & Releases Installation and Maintenance Online-Hilfe User Documentation
Forums Reporting Bugs Demo Installation
ILIAS news blog ILIAS in Practice Didactic Templates Plug-Ins
Getting Support Service Provider Donation
Development
Software Development
Feature Wiki Roadmap and Releases
Reporting Bugs Development Guide
ILIAS Coordination Team Donation
Community
Community
ILIAS Society Vereinsmitglieder - Society Members
Forums ILIAS Conference ILIAS Development Conference
User Groups Special Interest Groups (SIG)
Donation

Zoeken

»

Kruimelpad

ilias.de » Software Development » Performance Wiki

Performance Wiki

Information about performance tuning for bigger installations

Tabs

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: 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

Last edited: 14. Okt 2011, 12:11, [jluetzen]

Permanente link: