Following informations, 




GLPI version: 0.85.4 

Server (physical): CPU Intel Xeon E5620 2.40GHz, RAM 8GB (1.5GB free), Not Swap 
Web server: Apache 2.2.9-10 
PHP release: 5.3.3-7 
SQL application, and engine: MySQL 5.1.49-3 





Queries: 

1 - Search Requester in "Assistance>Tickets" (47 sec); 

2 - Time to loading " Administration>Users" (12 sec); 

3 - Search Users in "Administration>Users" (8 sec). 







Best regards, 




Douglas Fernandes 
IT Specialist 
Grupo de Governança de TIC 
Coordenadoria de Infraestrutura de Tecnologia 
da Informação e Comunicação - COTEC 
SECRETARIA DO PLANEJAMENTO E GESTÃO - SEPLAG 
GOVERNO DO ESTADO DO CEARÁ 



----- Mensagem original -----

De: glpi-dev-requ...@gna.org 
Para: glpi-dev@gna.org 
Enviadas: Quarta-feira, 20 de maio de 2015 10:02:09 
Assunto: Glpi-dev Digest, Vol 119, Issue 5 

Send Glpi-dev mailing list submissions to 
glpi-dev@gna.org 

To subscribe or unsubscribe via the World Wide Web, visit 
https://mail.gna.org/listinfo/glpi-dev 
or, via email, send a message with subject or body 'help' to 
glpi-dev-requ...@gna.org 

You can reach the person managing the list at 
glpi-dev-ow...@gna.org 

When replying, please edit your Subject line so it is more specific 
than "Re: Contents of Glpi-dev digest..." 


Today's Topics: 

1. Request for analysis of response time issue (Douglas P. Fernandes) 
2. Re: Request for analysis of response time issue (David DURIEUX) 
3. Re: Request for analysis of response time issue (Moron, Olivier) 


---------------------------------------------------------------------- 

Message: 1 
Date: Wed, 20 May 2015 09:45:10 -0300 (BRT) 
From: "Douglas P. Fernandes" <douglas.fernan...@seplag.ce.gov.br> 
To: glpi-dev@gna.org 
Subject: [Glpi-dev] Request for analysis of response time issue 
Message-ID: 
<59863347.13920691.1432125910402.javamail.zim...@seplag.ce.gov.br> 
Content-Type: text/plain; charset="utf-8" 



Dear Representative. 




We are committed to adopt GLPI here, at Seplag (Seplag is a State Secretary, 
State of Cear?). We have 150 thousand potential users, among all the public 
users. 




At assay phase, we found a problem regarding Requester, Ticket Form: search. It 
takes 47 seconds to retrieve data. The same search, at Administration ? User, 
takes about 08 (eight) seconds. It seems to us that a response time of 8 
seconds is too much, let alone 47 seconds. We wonder if there's a way to 
enhance this search mechanism? If so, this would be decisive for our intent to 
adopt this excellent software. 




Best regards, 


Att, 

Douglas Fernandes 
Especialista em TI 
Grupo de Governan?a de TIC 
Coordenadoria de Infraestrutura de Tecnologia 
da Informa??o e Comunica??o - COTEC 
SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG 

(85) 3101-4540 / (85) 9121-9564 

-------------- next part -------------- 
An HTML attachment was scrubbed... 
URL: </public/glpi-dev/attachments/20150520/c4c799dd/attachment.html> 

------------------------------ 

Message: 2 
Date: Wed, 20 May 2015 14:56:56 +0200 
From: David DURIEUX <d.duri...@siprossii.com> 
To: glpi-dev@gna.org 
Subject: Re: [Glpi-dev] Request for analysis of response time issue 
Message-ID: <20150520145656.18de7...@siprossii.com> 
Content-Type: text/plain; charset=utf-8 

Le Wed, 20 May 2015 09:45:10 -0300 (BRT) 
"Douglas P. Fernandes" <douglas.fernan...@seplag.ce.gov.br> a ?crit: 

> 
> 
>Dear Representative. 
> 

Hi 

> 
> 
>We are committed to adopt GLPI here, at Seplag (Seplag is a State 
>Secretary, State of Cear?). We have 150 thousand potential users, 
>among all the public users. 
> 
> 
> 
> 
>At assay phase, we found a problem regarding Requester, Ticket Form: 
>search. It takes 47 seconds to retrieve data. The same search, at 
>Administration ? User, takes about 08 (eight) seconds. It seems to us 
>that a response time of 8 seconds is too much, let alone 47 seconds. 
>We wonder if there's a way to enhance this search mechanism? If so, 
>this would be decisive for our intent to adopt this excellent 
>software. 

It's not normal, 
give the version of: 

* PHP 

* MySQL 

Is the server swap ? 

David 
++ 

> 
> 
>Best regards, 
> 
> 
>Att, 
> 
>Douglas Fernandes 
>Especialista em TI 
>Grupo de Governan?a de TIC 
>Coordenadoria de Infraestrutura de Tecnologia 
>da Informa??o e Comunica??o - COTEC 
>SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG 
> 
>(85) 3101-4540 / (85) 9121-9564 
> 



------------------------------ 

Message: 3 
Date: Wed, 20 May 2015 13:01:54 +0000 
From: "Moron, Olivier" <olivier.mo...@araymond.com> 
To: Liste de diffusion des developpeurs GLPI <glpi-dev@gna.org> 
Subject: Re: [Glpi-dev] Request for analysis of response time issue 
Message-ID: 
<080df555e8a78147a053578ec592e83901252d2...@arexch34.ar.ray.group> 
Content-Type: text/plain; charset="utf-8" 

Hello, 

I may help you, but I need a little bit more info about your configuration. 

Which GLPI version? 
What is the server (virtual or physical, CPU, RAM, HDD,?)? 
What is the web server? 
What is the PHP release? 
What is the SQL application, and engine (MySQL, MariaDB, MyISAM, INNODB)? 
What queries did you do to get this figures? 
? 

Here is our current configuration: 
Server: Windows 2008 R2 (on a ESX VMWare) 64bits 
CPU: 4 cores 
RAM: 8GB 
HD: 20GB 
Web server: IIS7 (64bits) 
PHP: 5.4.14 64bits 
DB: MySQL 5.6.10 64bits 
DB Engine: myISAM 

DB size is 3GB 
Records figures: 
Ticket qt: 188640 
Users: 7941 
Entities: 970 
Computers: 11462 
Software: 231143 
Logs: 15818092 

They are some solution to improve Tickets and Users default requests, but you 
need to touch a little bit source files. 

Regards, 

Olivier MORON 
Miscellaneous Program Member 

RAYNET SNC 
Tel : +33 4 76 33 49 52 
Fax: +33 4 76 70 56 63 


From: Glpi-dev [mailto:glpi-dev-boun...@gna.org] On Behalf Of Douglas P. 
Fernandes 
Sent: Wednesday, May 20, 2015 2:45 PM 
To: glpi-dev@gna.org 
Subject: [Glpi-dev] Request for analysis of response time issue 


Dear Representative. 



We are committed to adopt GLPI here, at Seplag (Seplag is a State Secretary, 
State of Cear?). We have 150 thousand potential users, among all the public 
users. 



At assay phase, we found a problem regarding Requester, Ticket Form: search. It 
takes 47 seconds to retrieve data. The same search, at Administration ? User, 
takes about 08 (eight) seconds. It seems to us that a response time of 8 
seconds is too much, let alone 47 seconds. We wonder if there's a way to 
enhance this search mechanism? If so, this would be decisive for our intent to 
adopt this excellent software. 



Best regards, 


Att, 

Douglas Fernandes 
Especialista em TI 
Grupo de Governan?a de TIC 
Coordenadoria de Infraestrutura de Tecnologia 
da Informa??o e Comunica??o - COTEC 
SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG 


(85) 3101-4540 / (85) 9121-9564 

-------------- next part -------------- 
An HTML attachment was scrubbed... 
URL: </public/glpi-dev/attachments/20150520/db40be19/attachment.html> 

------------------------------ 

Subject: Digest Footer 

_______________________________________________ 
Glpi-dev mailing list 
Glpi-dev@gna.org 
https://mail.gna.org/listinfo/glpi-dev 


------------------------------ 

End of Glpi-dev Digest, Vol 119, Issue 5 
**************************************** 

_______________________________________________
Glpi-dev mailing list
Glpi-dev@gna.org
https://mail.gna.org/listinfo/glpi-dev

Reply via email to