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