Hi Thank you for the quick reply. I have to query vertices based on multiple <key,value> pairs so that rules out the option of using graph.getVertices(key,value).
Also, Initially I tried to query without creating the indices >> graph.query().has(key1,value1)....has(key2,value2).hasNot(key).vertices(), which was taking forever but after creating the indices it became faster but eventually it slowed down when the number of vertices crossed 1000 or so. On Friday, 19 December 2014 16:19:26 UTC+5:30, Enrico Risa wrote: > > Hi vaibhav > > seems that the index is not used. > instead of using graph.query().has(key1,value1) > could you try the api > > graph.getVertices(iKey, Object iValue) > > for each key that you have? > > See here how to use the index > > > http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Database-Tinkerpop.html#use-indices > > > 2014-12-19 11:21 GMT+01:00 vaibhav vabs <[email protected] > <javascript:>>: >> >> Hi, >> >> I am using the Blueprints implementation of the graph database OrientDB >> to maintain my graph. The database is plocal and is located on a remote >> server. Snapshot 1.7.6 is used for all the referenced orientdb files. >> >> Operations- >> >> Adding vertex and edges in the graph. >> >> Retrieving vertices from the graph based on some <key,value> pairs >> where those <key> are set as index using >> graph.createIndex(key,Vertex.class); >> >> Each vertex has around 30 key value pairs out of which 13 of them are >> indexed >> >> Querying is done by using the blueprint API, >> graph.query().has(key1,value1)....has(key2,value2).hasNot(key).vertices() >> >> Issues- >> >> Initially when the graph is empty, adding and querying is fast >> >> When the number of vertices in the graph cross the 1000 mark, adding >> of vertices and querying becomes very slow. >> >> Is there some configuration on the server which can speed up the >> process ?? I tried enabling the cache.level1 and cache.level2. >> >> Am I not using the query correctly ?? >> >> I am using the transactional graph instance of OrientGraph and I call >> graph.commit() after adding vertices and edges. >> >> Thank you in advance. >> >> Regards, >> Vaibhav >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
