Show Advanced KnowledgeHide Advanced Knowledge

Abandon Database Benchmark

1 Reasons to Abandon Feature

Killing, Alexander [alex], 19 Apr 2021: The benchmark class ilBenchmark (Services/Utitilities) has been used to perform code profiling in the past. Due to the performance footprint of the feature we removed the class use from the ILIAS code, except for the Database service. I will stop to maintain this class, so either it is moved to the database service or the remaining feature is abandoned.

This FW page suggests to abandon the database benchmark feature. If anyone would like to keep it alive, please add a comment to this page and/or get in contact with Schmid, Fabian [fschmid].

2 Technical Information

No technical issues.

3 Contact

• Author of the Request: Killing, Alexander [alex]
• Maintainer: Killing, Alexander [alex] (implicit)
  
• Implementation of the feature is done by: {The maintainer must add the name of the implementing developer.}

4 Funding

Removing the feature from the ILIAS code base might need funding. If you are interest in funding this request, please add your name and institution to this list.

• ...

5 Discussion

Use the following discussion section to express your objections against this request or your consent to get rid of this feature.

Amstutz, Timon [amstutz], 2020-05-03: We checked into this again. We believe that some kind of benchmarking like this is very valuable. It helped to find various perf. issues in the recent past. It is far more useful than e.g. slow query look for certain scenarios. We usually use it for a context like this:

• A page takes a suspiciously long to load for a given user.
• Reload page while measuring.
• Find slow queries, or just regular queries that take longer than they sould according to the available data and content.

This can even be performed by a user without any technical insight. A small selection of issues than have been found (or feature was helpful in analyzing) this way:

• https://mantis.ilias.de/view.php?id=28969
• https://mantis.ilias.de/view.php?id=28810
• https://mantis.ilias.de/view.php?id=28404
• https://mantis.ilias.de/view.php?id=28711
• https://mantis.ilias.de/view.php?id=28718
• https://mantis.ilias.de/view.php?id=28714
• https://mantis.ilias.de/view.php?id=28403
• https://mantis.ilias.de/view.php?id=28280
• https://mantis.ilias.de/view.php?id=28416
• https://mantis.ilias.de/view.php?id=28365

We are willing to invest into improving the feature, e.g. reducing the footpring or centralizing it better.

JourFixe, ILIAS [jourfixe], 03 MAY 2021 : Fabian Schmid and Timon Amstutz will discuss about a possible future of the feature. Depending on their decision we keep the feature or abandon it.

6 Implementation

The Feature has NOT been removed in ILIAS. In ILIAS 9 there should be a refactoring for this Component/feature to keep it, otherwise we would suggest to remove it with ILIAS 9.

Removed Testcases

The following testcases have been removed from Testrail or modified because the feature is no longer part of the ILIAS core.

• {Test case number linked to Testrail} : {test case title}

Approval

Approved at {date} by {user}.