trying to find a document in Relation tab is too slow
Using the autocomplete widget trying to find a document in the relation tab is extremly slow, and most of the time does not provide a result
The postmaster process goes up to 100%
Of course, the search process keeps running in background leading to this kind of error
"Votre demande n'a pas été prise en compte, car vous avez déjà une requête en cours de traitement, merci de patienter."
The same search in the quick search widget behaves normally (from 1 to 5 seconds depending on server load)
There is some trace in the log about a Malformed security token : http://pastebin.com/wKC8wnXs
I'm running Nuxeo 5.8.
The malformed security token errors seem to be linked to the opensocial dashboard (where shinding is involved), in which case this is unrelated to the original issue.
The quick search suggestion is not using the same code, maybe the select2 widget is an issue in your case because too many requests are sent to the server (see https://jira.nuxeo.com/browse/NXP-14644), but that's just a guess.
The pasted query is the only slow query that occurs.