Hi Lui,
OrientDB performs aggregate operations in memory, so in this case you just
have to give it some more heap memory. To do it, just edit the server.sh
and set -Xmx to 1024 or 2048, it should be enough
Thanks
Luigi
2016-09-08 19:14 GMT+02:00 'Lui Neumann' via OrientDB <
I have a database with
1 milion researches (psq) 1 milion publications (pub) 12.5 milion edges
between psq and pub
I execute the querie
SELECT psq1.psq_nome AS nomePesquisador, COUNT(pub1) AS qtdPub
FROM (
MATCH
{class:Pesquisador, as:psq1}.outE("PUBLICOU").inV(){as:pub1}
RETURN