[
http://jira.nuxeo.org/browse/NXP-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-4071:
-----------------------------------
Status: Open (was: Triage)
> 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
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> 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
