Edge creation taking too much time


Ankur Goel <ankur...@...>
 

Hi,

I am having  (3 node cassandra cluster + single node solr cloud).

lead=g.V().has("lid", 15151515);
g.V(lead).as("l1").V().has("vl","tag").has("mob",P.eq(lead1.value("mob"))).has("lid",P.gt(lead1.value("lid"))).addE("direct").from("l1").property("reason","mob");

Using above code i am creating edges and vertex is approx 1 million.

composite index has been created on mob and lid and vl property key on vertex.

Above command takes couple of minutes, my java client is directly connected with solr and cassandra. i a not using gremlin server to fire query.

Please suggest.

~


Robert Dale <rob...@...>
 

Your composite index won't used for all three properties because it contains a range predicate gt(). You can check what, if any, indexes are being used by using 'profile()'.  You may want to create a mixed index with all three properties and see if that helps.  Separately, if there is no contention between vertexes, you could parallelize the requests. Also play with batch/commit sizes (1k - 10k).

Robert Dale

On Fri, Oct 6, 2017 at 7:35 AM, Ankur Goel <ankur...@...> wrote:
Hi,

I am having  (3 node cassandra cluster + single node solr cloud).

lead=g.V().has("lid", 15151515);
g.V(lead).as("l1").V().has("vl","tag").has("mob",P.eq(lead1.value("mob"))).has("lid",P.gt(lead1.value("lid"))).addE("direct").from("l1").property("reason","mob");

Using above code i am creating edges and vertex is approx 1 million.

composite index has been created on mob and lid and vl property key on vertex.

Above command takes couple of minutes, my java client is directly connected with solr and cassandra. i a not using gremlin server to fire query.

Please suggest.

~

--
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgraph-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/f225fff9-d2e5-40a5-ab4c-ae6d4a042bca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.