From: Glpi-dev [mailto:glpi-dev-boun...@gna.org] On Behalf Of Frederico Gendorf
Sent: Thursday, May 21, 2015 2:13 PM
To: Liste de diffusion des developpeurs GLPI
Subject: Re: [Glpi-dev] Glpi-dev Digest, Vol 119, Issue 7
Hi Douglas, you can optimize you database creating index for those columns
Hi Douglas, you can optimize you database creating index for those
columns *`glpi_users`.`begin_date`
`glpi_users`.`end_date`*
*ALTER TABLE `glpi`.`glpi_users` ADD INDEX `begin_date` (`begin_date`
ASC),ADD INDEX `end_date` (`end_date` ASC);*
try it and say to us the result!
[]s
*Frederico Gend
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 9:11 PM
To: glpi-dev@gna.org
Subject: Re: [Glpi-dev] Glpi-dev Digest, Vol 119, Issue 7
Hi, friends.
We made
,
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 9:11 PM
To: glpi-dev@gna.org
Subject: Re: [Glpi-dev] Glpi-dev Digest
Hi, friends.
We made some tests on GLPI Tables and some assays regarding queries, too. This
query bellow performed 15 sec to retrieve data from DB, what enforces our idea
toward problem related to query criteria, not DB at all.
SELECT DISTINCT `glpi_users`.*
FROM `glpi_users` LEFT JOIN `g
