thanks well thats what I thought. one more thing while using the DB.command() to execute query can we externally set when to commit data into database like gremlin. In gremlin we can specify after insertion of how many records the database should commit. May be that can help me in getting better performance
On Friday, November 3, 2017 at 2:08:15 PM UTC+5:30, Luigi Dell'Aquila wrote: > > Hi Shrikant, > > There are at least two factors that can impact performance here: > > - OrientDB does some caching of SQL statements, so the first time you > execute a query it has to be parsed from scratch, while the second time you > will have the AST in cache > - there is a layer, called diskCache, that keeps recently used data in > memory, so that you don't have to access disk to query it, probably this is > the part that impacts your case the most > > Thanks > > Luigi > > > 2017-11-03 9:00 GMT+01:00 shrikant pachauri <sk.pac...@gmail.com > <javascript:>>: > >> >> Greeting >> >> I am trying to insert say 10k vertices in graph DB. I am using a script >> file in javascript where I am using Orient DBs native query language. Now >> after creating a class from the vertices when i ran the query for the first >> time it takes me about 2.51s. Now if I ran the same query again it takes me >> about 0.92s to insert the 10k records. >> >> Now my question is this is there any sort of caching or some other >> mechanism which makes my execution of the second query faster than before. >> I have a perspective that May be it stored the compiled query of the first >> time and it does not need to compile the query next time in case it >> encounter the same query. >> >> Any help would be appreciated >> >> -- >> >> --- >> 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 orient-databa...@googlegroups.com <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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
