You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2017-07-18 09:18:03

hirnfred
Member
From: Berlin
Registered: 2012-05-26
Posts: 22

search "and not" in "software" takes very long time

Everytime when executing this specific search, it takes about 6 minutes...

With GLPI in Version 9.1.1 and also in 9.1.4.
Virtual Machine with 4 GB RAM an 4 CPUS (Ubuntu-Server 14)

Any help very much appreciated!


Ubuntu-Server 14.04 LTS
PHP 7.2.13
glippy 9.4.1.1
ocsinventory-ng-Plugin 1.6.0

Offline

#2 2017-07-19 12:49:00

grajek
Member
Registered: 2015-03-16
Posts: 72

Re: search "and not" in "software" takes very long time

Try disabling financial information in Setup=>Assets->Enable financial and administrative information by default=No.


GLPI 9.5.1 CentOS

Offline

#3 2017-07-20 05:19:30

hirnfred
Member
From: Berlin
Registered: 2012-05-26
Posts: 22

Re: search "and not" in "software" takes very long time

it was already disabled.


Ubuntu-Server 14.04 LTS
PHP 7.2.13
glippy 9.4.1.1
ocsinventory-ng-Plugin 1.6.0

Offline

#4 2017-07-20 05:25:04

hirnfred
Member
From: Berlin
Registered: 2012-05-26
Posts: 22

Re: search "and not" in "software" takes very long time

my search is intended to find Computers that don't have a specific Software installed.
Perhaps there is a plugin for that kind of report available?


Ubuntu-Server 14.04 LTS
PHP 7.2.13
glippy 9.4.1.1
ocsinventory-ng-Plugin 1.6.0

Offline

#5 2017-08-02 14:37:31

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: search "and not" in "software" takes very long time

More you have columns displayed, more the request is long


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#6 2017-08-03 11:55:04

hirnfred
Member
From: Berlin
Registered: 2012-05-26
Posts: 22

Re: search "and not" in "software" takes very long time

WOW !

Now the search takes only 2 seconds, when reduced to only one column "Name", which is all I need for this kind of search

Merci beaucoups !

But then the next question / request: Is ist possible to create more than one personal view?

Gruss
Uwe


Ubuntu-Server 14.04 LTS
PHP 7.2.13
glippy 9.4.1.1
ocsinventory-ng-Plugin 1.6.0

Offline

#7 2017-08-03 18:10:55

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: search "and not" in "software" takes very long time

No. You can only have one personal view by item.
But you can create bookmarks


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB