optimize NXQL query evaluation for multiple documents retrieval (in a single
SQL request)
-----------------------------------------------------------------------------------------
Key: NXP-4071
URL: http://jira.nuxeo.org/browse/NXP-4071
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Affects Versions: 5.2.x
Reporter: Stéphane Lacoin
Assignee: Thierry Delprat
Priority: Critical
we have a NXQL query that looks like
SELECT * from File where filename like ....;
For now, that query generates :
* first an SQL statement that retrieve document IDs
* then multiple requests for each document (one for each document part).
That way of doing consumes a lot of resources on database side and is very long.
In that case, would that be possible, as we're retrieving always the same data,
to merge all these requests in a single one ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
