java - neo4j slow lucene index query -

java - neo4j slow lucene index query -

i'm retrieving info index in neo4j database, , i'm having problems execution time. i'm trying query count resulting values. in production database i'm doing more complex calculations. anyway, query looks this,

start person = node:user_index('muncipalitycode:(1278 or 1285 or 1283 or 1293 or 1284 or 1261 or 1282 or 1262 or 1281 or 1280 or 1273) ') homecoming count(person)

the count returns 278418 in approximately 20 seconds(2.5-3 seconds sec time, when cache warm). sure, i'm returning quite big dataset. however, not immense.

is there somewhere can cut down bottleneck or configuration settings should into? i've tried warming cache on startup, can't fit info in ram on production server, backfires(my server has 16gb ram).

my database has next attributes. 10 329 245 nodes 97 923 564 properties 50 697 532 relationships

i utilize luke verify whether problem in index or elsewhere in code. if corresponding luke query fast, problem lies elsewhere.

java neo4j cypher