optimize NXQL query evaluation for multiple documents retrieval (in a single SQL request)

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 ?