HI ak1002,
A database is a piece of software that can handle many concurrent queries at the same time.
Normally I try to find how to get one single query as fast as possible with profile, explain the proper model and constraints and indexes. For the biggest part a single query is processed in a single-thread and so occupying one core for a time period. When you know the time needed for that single query you can calculate how many of these queries can be processed by your system. So if a query takes 10ms one core can handle 100 queries per second, and in your case 4 cores (if i am right) can handle 400 of these queries per second.
So to get better performance for a single query it will help that your complete database fits in memory, so if possible the page-cache size should be bigger than the size on disk. This is not always possible, then it helps if you have a fast harddisk (you have an SSD which is ok). Also you will get better single query performance when you have a faster cpu (higher clock speed)... but that is normally a given which you cannot change.
You can also find some cypher tuning tips here: https://medium.com/neo4j/cypher-query-optimisations-fe0539ce2e5c
I hope this will help you.
regards
Kees Vegter
