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 < [email protected]>: > > 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 psq1, pub1 > ) > GROUP BY psq1 > ORDER BY qtdPub DESC, nomePesquisador > LIMIT 1000; > > OR > > SELECT out.psq_nome AS nomePesquisador, COUNT(in.@rid) AS qtdPub > FROM Publicou > GROUP BY out.psq_nome > ORDER BY qtdPub DESC, nomePesquisador > LIMIT 1000; > > Then there are Error of memory heap > > How I configure the OriuentDb to permit I execute this? > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
