performance - Neo4j Match / Retrieving Query taking too much time 25 sec -
my system 8 core , 16 gb ram. still traversing :user nodes takes time around 25 seconds.
i set 2 properties in neo4j-wrapper.conf :
wrapper.java.initmemory = 6144 wrapper.java.maxmemory = 12288
- :user returning fields 15-20;
- 2-3 indexes (created_at have index)
- sorting done on created_at desc
- total 5 million nodes having database size of 8gb
- :user nodes 4 million.
- pagination done. per page 10 records fetched.
- without order gives results in 0.3 seconds.
match (u:user) return id(u) id, u.username, u.email, (..15 more fields..), u.created_at created_at order created_at desc skip 0 limit 10
how can reduce response time neo4j server? neo4j.properties can set reduce execution time?
i've had luck setting both init memory , max memory same value (so jvm doesn't have resizing) , setting garbage collection. give these values shot in conf file:
-xmx4g #max -xms4g #init -xx:+useconcmarksweepg #garbage collector
Comments
Post a Comment