For example, MATCH (m:Product) WHERE 'moisturize' IN m._effect RETURN m In this query, '_effect' is a property of an array. When the query above returns non-empty results, it takes only 2ms, shown in the browser. And when the result set is empty, it takes over 100ms to complete. I already created…

@dana_canzano I have a general question on cypher query and times spent on them. In my application, the time allocated to neo4j queries is only <20 milliseconds per request. However, it seems I saw a lot of cyphers when it is a little complex, it takes more than 100 mill-seconds. Is this the reali…

What are your requirements? Is 100ms too long? Must all queries return in < 2ms ?? But also performance is a large domain not just of Neo4j but any database. Are you queries written in a manner that is to achieve performance? Do you have indexes were they would prove beneficial? Also, perfor…

For instance, if my QPS requirement is 500, does that mean in every millisecond, it has to complete 2 requests?

yes from a simple mathematical perspective thats correct.

That seems too harsh, but it is a real requirement. DB query alone may exceed that limit. @dana_canzano any suggestion to achieve that? Assuming that my hardware and other software is optimized to the best extent, neo4j can also make sure most queries to complete in a few milliseconds?

That seems too harsh, but it is a real requirement thats not a question i can answer. The requirement would need to be set by the end users. i.e. if for example you are doing real time stock trading analysis, maybe a 2ms response is required. Again its not something I can answer. also regar…

@dana_canzano . This is my code to execute the query for users to call. Regarding 'concurrent queries', you mean clients write concurrent code to make requests, or I need to write concurrent cypher/driver code for neo4j? with self.neo4j_driver.session() as session: return session.read_t…

By concurrent queries Im referring to the number of queries in flight/running at the same time regardless of if those queries are reads or writes. Let's say everyone ( where everyone = 50 people) arrives at the office at 9a and everyone logs in and everyone all at the same time issues a query to re…

So clients send concurrent requests to neo4j to get results. For the code example above, do I need to do something special to support concurrent requests either by coding or DB configuration, or it's inherently supported?

How to optimize queries on array properties?

Neo4j Graph Platform

dana_canzano (Dana Canzano) November 19, 2020, 9:38pm 2

this is effectively the same as Index on array which is to say that at this time we do not support indexing on array properties

Topic		Replies	Views
Extremely slow query when profile looks very good? Cypher	11	4211	October 3, 2019
Is this query speed normal? Neo4j Graph Platform	5	755	October 23, 2020
Indexing Array Properties Cypher	0	140	November 16, 2024
Dreadfully Long Query Times Cypher performance , cypher	5	487	October 2, 2020
Very slow performance when aggregate on node property Cypher performance	21	5025	December 21, 2020

How to optimize queries on array properties?

Related topics