Re: [orientdb] OrientDb - Performance and Capacity

2016-09-09 Thread Luigi Dell'Aquila
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 <

[orientdb] OrientDb - Performance and Capacity

2016-09-09 Thread '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