much *F*aster of course, not *m*aster... 2015-04-21 17:10 GMT+02:00 Luigi Dell'Aquila <luigi.dellaqu...@gmail.com>:
> Ok, I saw the remote only now. If you want to go much master you should > use plocal (this avoids network overhead). > If you need other clients to connect to the db in remote mode, you can > start the server as embedded, see > http://orientdb.com/docs/last/Embedded-Server.html > > 2015-04-21 17:09 GMT+02:00 Luigi Dell'Aquila <luigi.dellaqu...@gmail.com>: > >> Hi Sven, >> >> how are you connected to the db (remote or plocal)? >> Could you post the details of your db schema, in terms of classes, >> properties and index definitions? >> >> Thanks >> >> Luigi >> >> >> 2015-04-21 17:03 GMT+02:00 Sven Hodapp <sven.hod...@gmail.com>: >> >>> Hi together, >>> >>> for my project I want to import a lot of data into the database. But the >>> data should be de-duplicated. >>> >>> First of all, without de-duplication the insertion takes about 500 ms (a >>> minimal test set): >>> >>> docelem = graph.addVertex("class:DocElem", "uri", uri, "type", type, >>> "model", model); >>> >>> docelem.setProperties(attrs); >>> >>> graph.commit(); >>> >>> >>> Now I *don't* want that the is uploaded twice, so I'll check it like >>> this, if it's already in the database: >>> >>> >>> Iterable<Vertex> iter = graph.query() >>> >>> .has("uri", Compare.EQUAL, uri) >>> >>> .limit(1) >>> >>> .vertices(); >>> >>> >>> Then, with iter.iterator().hasNext() I'm checking, if the vertex is >>> already in the database. But this is dead slow (even indexed, or I've made >>> a mistake)! Now it takes about 15 s for inserting. >>> >>> >>> You can suggest a better solution? The best case would be, if I don't >>> have to call the database; and the database recognizes that the requested >>> uri is already inserted and may only update the entry, or something like >>> that! >>> >>> >>> Note 1: With println instead of db-insert the code needs about 50 ms to >>> fetch/create the data. Is is possible to go faster? >>> >>> Note 2: I'm using OrientDB 2.1-rc1 with remote connection (on the same >>> host). >>> >>> >>> Regards, >>> >>> Sven >>> >>> -- >>> >>> --- >>> 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. >>> >> >> > -- --- 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.
