Hi Bryan Are you inserting through plocal?
how many records do you have to insert? After how many records do you see the slow down? Did you check the memory of your inserting batch? Enrico 2015-09-14 17:37 GMT+02:00 Bryan <[email protected]>: > Okay, I created issue #4965 > <https://github.com/orientechnologies/orientdb/issues/4965>. > > What about the 2nd issue I have? Is there some reason inserting things > keeps getting slower and slower until I restart OrientDB? > > On Friday, September 11, 2015 at 10:50:49 AM UTC-7, Bryan wrote: >> >> Hi all, >> >> I have been experimenting with an OrientDB setup (version 2.1.0 - plocal >> connection) and noticed a very large difference in performance when passing >> in an OClass parameter to a LINKSET vs leaving it out. >> Example: >> >> OClass logItem = schema.createClass("log_item"); >> logItem.createProperty("timestamp", OType.DATETIME); >> logItem.createProperty("message", OType.STRING); >> >> OClass log = schema.createClass("log"); >> log.createProperty("name", OType.STRING); >> >> and >> >> log.createProperty("log_items", OType.LINKSET, logItem); >> VS >> log.createProperty("log_items", OType.LINKSET); >> >> I tested inserting 1 log and 1000 log items into the log. >> i.e. >> // log = Get the log... >> ODocument logItem = new ODocument("log_item"); >> logItem.field("timestamp", new Date()); >> logItem.field("message", "Hello World"); >> logItem.save(); >> >> >> Set<OIdentifiable> logItems = log.field("log_items"); >> logItems.add(logItem.getIdentity()); >> log.save(); >> >> >> WITH OClass param => 38.8 seconds >> WITHOUT OClass param => 1.5 seconds >> >> So really I have 2 questions: >> 1) Why are updates so much faster when I DON'T add the OClass parameter. >> Is there a reason why I want to leave it in? >> >> 2) I'm experiencing decrease in insertion speed as the number of >> documents grows. If I shutdown OrientDB and start again I see speed go up >> temporarily until I insert more records and it continues to slow down... >> I've tried committing after every ".save()". Am I missing something? >> >> Thanks! >> > -- > > --- > 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. > -- --- 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.
