Custom asset definitions add noticeable request performance hit

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.

https://glpi-project.org

GNU General Public License v3.0

4.3k stars 1.29k forks source link

Custom asset definitions add noticeable request performance hit #18304

Open cconard96 opened 1 day ago

cconard96 commented 1 day ago

I've noticed that as I add more custom asset definitions for testing (or from running E2E tests locally), almost every request to a PHP script has gotten nearly 10x slower than what it is in 10.0/bugfixes. Currently, I have 70 asset definitions with a few custom fields in each. It isn't clear yet if the issue is the number of definitions, number of custom fields, specific capacities, or a combination of everything.

cconard96 commented 1 day ago

Identified the IsInventoriableCapacity as the source of the performance hit. I only had a single asset definition with it enabled and it alone was adding 550ms to the response times.

AdrienClairembault commented 1 day ago

I confirm on my side too.

Without IsInventoriableCapacity:

With one IsInventoriableCapacity: