Search and Computer overview takes very very log if Memory and Hard Drive Size is included in view

Question

Search and Computer overview takes very very log if Memory and Hard Drive Size is included in view

Opened this issue 2 months ago · 0 comments

Megachip commented 2 months ago

Code of Conduct

I agree to follow this project's Code of Conduct

Is there an existing issue for this?

I have searched the existing issues

Version

10.0.18

Bug description

When adding Components - Memory and/or Components - Hard drive size to Select default items to show, the loading time of gobal searches and opening Computer Assets tooks very very long.

Relevant log output

Page URL

https://glpi.emessage.cloud/front/computer.php, https://glpi.emessage.cloud/front/search.php?globalsearch

Steps To reproduce

Adding these both values to personal view
Start a search or open the computer view

Your GLPI setup information

Information about system installation and configuration

GLPI 10.0.18 ( => /var/www/glpi)
Installation mode: TARBALL
Current language:en_GB

Server

Operating system: Linux glpi 6.8.0-55-generic #57-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 12 23:42:21 UTC 2025 x86_64
PHP 8.3.6 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, bz2, calendar, ctype,
curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd,
openssl, pcre, pdo_mysql, posix, random, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm,
tokenizer, xml, xmlreader, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
upload_max_filesize="2M" disable_functions=""
Software: Apache/2.4.58 (Ubuntu) (Apache/2.4.58 (Ubuntu) Server at glpi.emessage.cloud Port 443
)
Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0
Server Software: Ubuntu 24.04
Server Version: 10.11.13-MariaDB-0ubuntu0.24.04.1
Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: glpiuser@xxx/glpidb
Host info: xxx via TCP/IP

PHP version (8.3.6) is supported.
Sessions configuration is OK.
Allocated memory is sufficient.
mysqli extension is installed.
Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter.
curl extension is installed.
gd extension is installed.
intl extension is installed.
zlib extension is installed.
The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.
Database engine version (10.11.13) is supported.
No files from previous GLPI version detected.
The log file has been created successfully.
Write access to /var/lib/glpi/_cache has been validated.
Write access to /var/lib/glpi/_cron has been validated.
Write access to /var/lib/glpi has been validated.
Write access to /var/lib/glpi/_dumps has been validated.
Write access to /var/lib/glpi/_graphs has been validated.
Write access to /var/lib/glpi/_lock has been validated.
Write access to /var/lib/glpi/_pictures has been validated.
Write access to /var/lib/glpi/_plugins has been validated.
Write access to /var/lib/glpi/_rss has been validated.
Write access to /var/lib/glpi/_sessions has been validated.
Write access to /var/lib/glpi/_tmp has been validated.
Write access to /var/lib/glpi/_uploads has been validated.

Web server root directory configuration seems safe.
Sessions configuration is secured.
OS and PHP are relying on 64 bits integers.
exif extension is installed.
ldap extension is installed.
openssl extension is installed.
Following extensions are installed: bz2, Phar, zip.
Zend OPcache extension is installed.
Following extensions are installed: ctype, iconv, mbstring, sodium.
Write access to /var/www/glpi/marketplace has been validated.
Access to timezone database (mysql) is not allowed.

GLPI constants

GLPI_ROOT: "/var/www/glpi"
GLPI_CONFIG_DIR: "/etc/glpi/"
GLPI_VAR_DIR: "/var/lib/glpi"
GLPI_LOG_DIR: "/var/log/glpi"
GLPI_MARKETPLACE_DIR: "/var/www/glpi/marketplace"
GLPI_USE_CSRF_CHECK: "1"
GLPI_CSRF_EXPIRES: "7200"
GLPI_CSRF_MAX_TOKENS: "100"
GLPI_USE_IDOR_CHECK: "1"
GLPI_IDOR_EXPIRES: "7200"
GLPI_ALLOW_IFRAME_IN_RICH_TEXT: false
GLPI_SERVERSIDE_URL_ALLOWLIST: ["#^http://[^@:]+(:80)?(/.)?$#","#^https://[^@:]+(:443)?(/.)?$#","#^feed://[^@:]+(/.)?$#"]
GLPI_DISALLOWED_UPLOADS_PATTERN: "/\.(php\d|phar)$/i"
GLPI_TELEMETRY_URI: "https://telemetry.glpi-project.org"
GLPI_INSTALL_MODE: "TARBALL"
GLPI_NETWORK_MAIL: "glpi@teclib.com"
GLPI_NETWORK_SERVICES: "https://services.glpi-network.com"
GLPI_MARKETPLACE_ALLOW_OVERRIDE: true
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true
GLPI_USER_AGENT_EXTRA_COMMENTS: ""
GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: "1"
GLPI_AJAX_DASHBOARD: "1"
GLPI_CALDAV_IMPORT_STATE: 0
GLPI_DEMO_MODE: "0"
GLPI_CENTRAL_WARNINGS: "1"
GLPI_TEXT_MAXSIZE: "4000"
GLPI_DOC_DIR: "/var/lib/glpi"
GLPI_CACHE_DIR: "/var/lib/glpi/_cache"
GLPI_CRON_DIR: "/var/lib/glpi/_cron"
GLPI_DUMP_DIR: "/var/lib/glpi/_dumps"
GLPI_GRAPH_DIR: "/var/lib/glpi/_graphs"
GLPI_LOCAL_I18N_DIR: "/var/lib/glpi/_locales"
GLPI_LOCK_DIR: "/var/lib/glpi/_lock"
GLPI_PICTURE_DIR: "/var/lib/glpi/_pictures"
GLPI_PLUGIN_DOC_DIR: "/var/lib/glpi/_plugins"
GLPI_RSS_DIR: "/var/lib/glpi/_rss"
GLPI_SESSION_DIR: "/var/lib/glpi/_sessions"
GLPI_TMP_DIR: "/var/lib/glpi/_tmp"
GLPI_UPLOAD_DIR: "/var/lib/glpi/_uploads"
GLPI_INVENTORY_DIR: "/var/lib/glpi/_inventories"
GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"
GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"
GLPI_I18N_DIR: "/var/www/glpi/locales"
GLPI_VERSION: "10.0.18"
GLPI_SCHEMA_VERSION: "10.0.18"
GLPI_MARKETPLACE_PRERELEASES: false
GLPI_MIN_PHP: "7.4.0"
GLPI_MAX_PHP: "8.4.0"
GLPI_YEAR: "2025"

Libraries

 

htmlawed/htmlawed version 1.2.14 in (/var/www/glpi/vendor/htmlawed/htmlawed)

phpmailer/phpmailer version 6.8.0 in (/var/www/glpi/vendor/phpmailer/phpmailer/src)

simplepie/simplepie version 1.5.8 in (/var/www/glpi/vendor/simplepie/simplepie/library)

tecnickcom/tcpdf version 6.8.0 in (/var/www/glpi/vendor/tecnickcom/tcpdf)

michelf/php-markdown in (/var/www/glpi/vendor/michelf/php-markdown/Michelf)

true/punycode in (/var/www/glpi/vendor/true/punycode/src)

iamcal/lib_autolink in (/var/www/glpi/vendor/iamcal/lib_autolink)

sabre/dav in (/var/www/glpi/vendor/sabre/dav/lib/DAV)

sabre/http in (/var/www/glpi/vendor/sabre/http/lib)

sabre/uri in (/var/www/glpi/vendor/sabre/uri/lib)

sabre/vobject in (/var/www/glpi/vendor/sabre/vobject/lib)

laminas/laminas-i18n in (/var/www/glpi/vendor/laminas/laminas-i18n/src)

laminas/laminas-servicemanager in (/var/www/glpi/vendor/laminas/laminas-servicemanager/src)

monolog/monolog in (/var/www/glpi/vendor/monolog/monolog/src/Monolog)

sebastian/diff in (/var/www/glpi/vendor/sebastian/diff/src)

donatj/phpuseragentparser in (/var/www/glpi/vendor/donatj/phpuseragentparser/src/UserAgent)

elvanto/litemoji in (/var/www/glpi/vendor/elvanto/litemoji/src)

symfony/console in (/var/www/glpi/vendor/symfony/console)

scssphp/scssphp in (/var/www/glpi/vendor/scssphp/scssphp/src)

laminas/laminas-mail in (/var/www/glpi/vendor/laminas/laminas-mail/src/Protocol)

laminas/laminas-mime in (/var/www/glpi/vendor/laminas/laminas-mime/src)

rlanvin/php-rrule in (/var/www/glpi/vendor/rlanvin/php-rrule/src)

ramsey/uuid in (/var/www/glpi/vendor/ramsey/uuid/src)

psr/log in (/var/www/glpi/vendor/psr/log/Psr/Log)

psr/simple-cache in (/var/www/glpi/vendor/psr/simple-cache/src)

psr/cache in (/var/www/glpi/vendor/psr/cache/src)

league/csv in (/var/www/glpi/vendor/league/csv/src)

mexitek/phpcolors in (/var/www/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)

guzzlehttp/guzzle in (/var/www/glpi/vendor/guzzlehttp/guzzle/src)

guzzlehttp/psr7 in (/var/www/glpi/vendor/guzzlehttp/psr7/src)

glpi-project/inventory_format in (/var/www/glpi/vendor/glpi-project/inventory_format/lib/php)

wapmorgan/unified-archive in (/var/www/glpi/vendor/wapmorgan/unified-archive/src)

paragonie/sodium_compat in (/var/www/glpi/vendor/paragonie/sodium_compat/src)

symfony/cache in (/var/www/glpi/vendor/symfony/cache)

html2text/html2text in (/var/www/glpi/vendor/html2text/html2text/src)

symfony/css-selector in (/var/www/glpi/vendor/symfony/css-selector)

symfony/dom-crawler in (/var/www/glpi/vendor/symfony/dom-crawler)

twig/twig in (/var/www/glpi/vendor/twig/twig/src)

twig/string-extra in (/var/www/glpi/vendor/twig/string-extra)

symfony/polyfill-ctype not found

symfony/polyfill-iconv not found

symfony/polyfill-mbstring not found

symfony/polyfill-php80 not found

symfony/polyfill-php81 not found

symfony/polyfill-php82 in (/var/www/glpi/vendor/symfony/polyfill-php82)

league/oauth2-client in (/var/www/glpi/vendor/league/oauth2-client/src/Provider)

league/oauth2-google in (/var/www/glpi/vendor/league/oauth2-google/src/Provider)

thenetworg/oauth2-azure in (/var/www/glpi/vendor/thenetworg/oauth2-azure/src/Provider)

LDAP directories

 

Server: 'xxx', Port: '389', BaseDN: 'OU=xxx,DC=xxx,DC=xxx,DC=local', Connection filter:

'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:

'CN=Administrator,OU=special,DC=xxx,DC=xxx,DC=local', Use TLS: none

SQL replicas

Not active

Notifications

Way of sending emails: PHP

Plugins list

actualtime Name: ActualTime Version: 3.2.0 State: Enabled
Install Method: Marketplace
positions Name: Cartography Version: 6.0.3 State: Enabled
Install Method: Marketplace
datainjection Name: Data injection Version: 2.14.1 State: Enabled
Install Method: Marketplace
archimap Name: Diagrams Version: 3.3.7 State: Not installed
Install Method: Marketplace
gantt Name: gantt Version: 1.1.1 State: Enabled
Install Method: Marketplace
geolocation Name: Geolocation Version: 1.0.0 State: Not installed
Install Method: Marketplace
glpiinventory Name: GLPI Inventory Version: 1.5.3 State: Enabled
Install Method: Marketplace
accounts Name: Konten Version: 3.0.4 State: Enabled
Install Method: Marketplace
resources Name: Mitarbeiter Version: 3.0.7 State: Not installed
Install Method: Marketplace
archires Name: Network architecture Version: 1.0.2 State: Enabled
Install Method: Marketplace
genericobject Name: Objects management Version: 2.14.14 State: Enabled
Install Method: Marketplace
order Name: Orders management Version: 2.11.1 State: Not installed
Install Method: Marketplace
serverhealthcheck Name: ServerHealthCheck Version: 1.0.0 State: Not installed
Install Method: Manual
manufacturersimports Name: Suppliers imports Version: 3.0.9 State: Enabled
Install Method: Marketplace
tasklists Name: Tasks list Version: 2.0.4 State: Enabled
Install Method: Marketplace
fields Name: Zusätzliche Felder Version: 1.21.22 State: Enabled
Install Method: Marketplace

Anything else?

The following statement took 30 secs - all others are fine.

SELECT DISTINCT `glpi_computers`.`id` AS id, 'aso' AS currentuser,
                        `glpi_computers`.`entities_id`, `glpi_computers`.`is_recursive`,  `glpi_computers`.`name` AS `ITEM_Computer_1`,
                        `glpi_computers`.`id` AS `ITEM_Computer_1_id`,
                        `glpi_entities`.`completename` AS `ITEM_Computer_80`,  `glpi_states`.`completename` AS `ITEM_Computer_31`,  `glpi_manufacturers`.`name` AS `ITEM_Computer_23`,  `glpi_computers`.`serial` AS `ITEM_Computer_5`,  `glpi_computertypes`.`name` AS `ITEM_Computer_4`,  `glpi_computermodels`.`name` AS `ITEM_Computer_40`,   GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`name`, '__NULL__'),
                                               '$#$',`glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`id`) ORDER BY `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`id` SEPARATOR '$$##$$')
                              AS `ITEM_Computer_45`,
                  
                  `glpi_locations`.`completename` AS `ITEM_Computer_3`,  `glpi_computers`.`date_mod` AS `ITEM_Computer_19`,   GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`designation`, '__NULL__'),
                                               '$#$',`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`) ORDER BY `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id` SEPARATOR '$$##$$')
                              AS `ITEM_Computer_17`,
                  
                  (SUM(`glpi_items_devicememories`.`size`) / COUNT(`glpi_items_devicememories`.`id`))
            * COUNT(DISTINCT `glpi_items_devicememories`.`id`) AS `ITEM_Computer_111`,  (SUM(`glpi_items_deviceharddrives`.`capacity`) / COUNT(`glpi_items_deviceharddrives`.`id`))
            * COUNT(DISTINCT `glpi_items_deviceharddrives`.`id`) AS `ITEM_Computer_115`,  `glpi_computers`.`last_inventory_update` AS `ITEM_Computer_9`,   GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`name`, '__NULL__'),
                                               '$#$',`glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`id`) ORDER BY `glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`id` SEPARATOR '$$##$$')
                              AS `ITEM_Computer_126`,
                  
                   GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_networkports`.`mac`, '__NULL__'),
                                               '$#$',`glpi_networkports`.`id`) ORDER BY `glpi_networkports`.`id` SEPARATOR '$$##$$')
                              AS `ITEM_Computer_21` 
FROM `glpi_computers`LEFT JOIN `glpi_entities` 
                                          ON (`glpi_computers`.`entities_id` = `glpi_entities`.`id`
                                              )LEFT JOIN `glpi_states` 
                                          ON (`glpi_computers`.`states_id` = `glpi_states`.`id`
                                              )LEFT JOIN `glpi_manufacturers` 
                                          ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id`
                                              )LEFT JOIN `glpi_computertypes` 
                                          ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id`
                                              )LEFT JOIN `glpi_computermodels` 
                                          ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id`
                                              ) LEFT JOIN `glpi_items_operatingsystems` 
                                          ON (`glpi_computers`.`id` = `glpi_items_operatingsystems`.`items_id`
                                              AND `glpi_items_operatingsystems`.`itemtype` = 'Computer'
                                              ) LEFT JOIN `glpi_operatingsystems`  AS `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`
                                          ON (`glpi_items_operatingsystems`.`operatingsystems_id` = `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`id`
                                              )LEFT JOIN `glpi_locations` 
                                          ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id`
                                              ) LEFT JOIN `glpi_items_deviceprocessors` 
                                          ON (`glpi_computers`.`id` = `glpi_items_deviceprocessors`.`items_id`
                                              AND `glpi_items_deviceprocessors`.`itemtype` = 'Computer'
                                              ) LEFT JOIN `glpi_deviceprocessors`  AS `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`
                                          ON (`glpi_items_deviceprocessors`.`deviceprocessors_id` = `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`
                                              ) LEFT JOIN `glpi_items_devicememories` 
                                          ON (`glpi_computers`.`id` = `glpi_items_devicememories`.`items_id`
                                              AND `glpi_items_devicememories`.`itemtype` = 'Computer'
                                              )  LEFT JOIN `glpi_items_deviceharddrives` 
                                          ON (`glpi_computers`.`id` = `glpi_items_deviceharddrives`.`items_id`
                                              AND `glpi_items_deviceharddrives`.`itemtype` = 'Computer'
                                              )  LEFT JOIN `glpi_ipaddresses`  AS `glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`
                                          ON (`glpi_computers`.`id` = `glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`mainitems_id`
                                              AND `glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`mainitemtype` = 'Computer'
                                               AND `glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`is_deleted` = '0' AND  NOT (`glpi_ipaddresses_3714572b4d6732a91ac0d68a00a3c328`.`name` = '') )  LEFT JOIN `glpi_networkports` 
                                          ON (`glpi_computers`.`id` = `glpi_networkports`.`items_id`
                                              AND `glpi_networkports`.`itemtype` = 'Computer'
                                              )  
WHERE  `glpi_computers`.`is_deleted` = 0  AND `glpi_computers`.`is_template` = 0  GROUP BY `glpi_computers`.`id` ORDER BY `ITEM_Computer_1` ASC  LIMIT 0, 20

So either display a warning on activating these calculated values or cache them in any way or do not do calculations in sql?