Will the index be used on the generated columns? if not, how can I request for this feature? It exists is all RDBMS.
say I have
CREATE INDEX ON :Label1(some_column) and
CREATE INDEX ON :Label2(some_other_column)
say in my WHERE clause I ...
I am doing an A/B testing to measure the throughput for the Creation of nodes in Neo4J. And I find throughput for creation of nodes decreases significantly as the number of properties increase.
Setup: Neo4j cluster 3.5.7 (3 core instances where one i...
@andrew.bowman converting integers to long doesn't sound efficent at all. but thats another problem in itself. As I said in my previous post I also did another experiment. which is
10 properties of type string length 6 vs 20 properties of type stri...
@andrew.bowman ok, I modified my benchmark code. Now I kept the total data size same when comparing the throughput between
10 properties of type long vs 20 properties of type int
Code for 10 properties of type long
There are no indices. Moreover I tried with indices and without indices and the slow down is very negligible.
"Seems like when you double the data that you're inserting, you're getting roughly double the execution time. That seems like a linear scali...