#1265: getFromLDAP optimization for groups retrival
----------------------------+-----------------------------------------------
Reporter: remi | Owner: anonymous
Type: enhancement | Status: new
Priority: normal | Milestone: 0.75
Component: Authentication | Version: 0.71.5
Severity: tweak | Keywords:
Cd: 1 (Low) |
----------------------------+-----------------------------------------------
Actual process :
* SELECT ID,ldap_field, ldap_value FROM glpi_groups
* Build a small array with unique ldap_field
* Build a big array with ID,ldap_field,ldap_value
* retrieve LDAP attribute (ldap_field = small array)
* build array with group membership (searching in the big array)
This could consume a lot of memory and time (if a lot of groups exists :
> 10000)
Proposed optimized process (to be discussed)
* SELECT DISTINCT ldap_field FROM glpi_groups
* Build a small array with unique ldap_field
* retrieve LDAP attribute (ldap_field)
* for each attribute of the current user search for group ID
(ldap_field,ldap_value)
* build array with group membership
This will use more SQL query, but smaller.
--
Ticket URL: <https://dev.indepnet.net/glpi/ticket/1265>
GLPI <https://dev.indepnet.net/glpi/>
Gestion Libre de Parc Informatique
_______________________________________________
Glpi-bugtrack mailing list
[email protected]
https://mail.gna.org/listinfo/glpi-bugtrack
