[xoops-trackers] [ xoops-Bugs-3534850 ] User Query takes too long

[SourceForge.net <no...@so...>]

Bugs item #3534850, was opened at 2012-06-13 05:06
Message generated for change (Settings changed) made by tatane72
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=430840&aid=3534850&group_id=41586

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core -  Core
Group: XOOPS 2.5.x
>Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: tatane tatane (tatane72)
Assigned to: MusS (forxoops)
Summary: User Query takes too long

Initial Comment:
the requette SELECT DISTINCT COUNT(u.uid) FROM users AS u LEFT JOIN groups_users_link AS m ON m.uid = u.uid WHERE ((level >= '0')) 

causes on erreur Numéro d'erreur: 1317
 Message d'erreur: exécution de la requête a été interrompue.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=430840&aid=3534850&group_id=41586