{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5566","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5566/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5566/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5566/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5566","id":125495264,"number":5566,"title":"Performance degradation of UPDATE with LOCK RECORD in 2.1.x","user":{"login":"kowalot","id":3010480,"avatar_url":"https://avatars.githubusercontent.com/u/3010480?v=3","gravatar_id":"","url":"https://api.github.com/users/kowalot","html_url":"https://github.com/kowalot","followers_url":"https://api.github.com/users/kowalot/followers","following_url":"https://api.github.com/users/kowalot/following{/other_user}","gists_url":"https://api.github.com/users/kowalot/gists{/gist_id}","starred_url":"https://api.github.com/users/kowalot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kowalot/subscriptions","organizations_url":"https://api.github.com/users/kowalot/orgs","repos_url":"https://api.github.com/users/kowalot/repos","events_url":"https://api.github.com/users/kowalot/events{/privacy}","received_events_url":"https://api.github.com/users/kowalot/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/performance","name":"performance","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"tglman","id":424369,"avatar_url":"https://avatars.githubusercontent.com/u/424369?v=3","gravatar_id":"","url":"https://api.github.com/users/tglman","html_url":"https://github.com/tglman","followers_url":"https://api.github.com/users/tglman/followers","following_url":"https://api.github.com/users/tglman/following{/other_user}","gists_url":"https://api.github.com/users/tglman/gists{/gist_id}","starred_url":"https://api.github.com/users/tglman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tglman/subscriptions","organizations_url":"https://api.github.com/users/tglman/orgs","repos_url":"https://api.github.com/users/tglman/repos","events_url":"https://api.github.com/users/tglman/events{/privacy}","received_events_url":"https://api.github.com/users/tglman/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/72","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.2.0-rc1","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/72/labels","id":1458008,"number":72,"title":"2.2.0-rc1","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":245,"closed_issues":15,"state":"open","created_at":"2015-12-13T18:50:39Z","updated_at":"2016-02-26T16:13:30Z","due_on":"2016-02-17T23:00:00Z","closed_at":null},"comments":31,"created_at":"2016-01-07T22:05:26Z","updated_at":"2016-03-01T07:57:20Z","closed_at":null,"body":"\r\nOne of the OrientDB internal tests  ConcurrentUpdatesTest:concurrentPessimisticSQLUpdates()\r\n(After adding time measurement available here   https://gist.github.com/anonymous/305d33338c9f94c12b55   )\r\n\r\nshows performance degradation of UPDATEs with pessimistic locking is much worse comparing to OrientDB 2.0.x\r\n\r\nBelow results on my test machine\r\n\r\nv2.1.8\r\nConcurrentUpdatesTest.concurrentPessimisticSQLUpdates()\r\nprivate final static int PESSIMISTIC_CYCLES = 10000;\r\nprivate final static int THREADS            = 12;\r\nElapsed time [ms]:79284\r\nRate ops/sec:1513\r\n\r\n\r\nv2.0.16\r\nConcurrentUpdatesTest.concurrentPessimisticSQLUpdates()\r\nprivate final static int PESSIMISTIC_CYCLES = 10000;\r\nprivate final static int THREADS            = 12;\r\nElapsed time [ms]:23581\r\nRate ops/sec:5088\r\n\r\n\r\nv2.0.8\r\nConcurrentUpdatesTest.concurrentPessimisticSQLUpdates()\r\nprivate final static int PESSIMISTIC_CYCLES = 10000;\r\nprivate final static int THREADS            = 12;\r\nElapsed time [ms]:17488\r\nRate ops/sec:6861\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/190601646","html_url":"https://github.com/orientechnologies/orientdb/issues/5566#issuecomment-190601646","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5566","id":190601646,"user":{"login":"kowalot","id":3010480,"avatar_url":"https://avatars.githubusercontent.com/u/3010480?v=3","gravatar_id":"","url":"https://api.github.com/users/kowalot","html_url":"https://github.com/kowalot","followers_url":"https://api.github.com/users/kowalot/followers","following_url":"https://api.github.com/users/kowalot/following{/other_user}","gists_url":"https://api.github.com/users/kowalot/gists{/gist_id}","starred_url":"https://api.github.com/users/kowalot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kowalot/subscriptions","organizations_url":"https://api.github.com/users/kowalot/orgs","repos_url":"https://api.github.com/users/kowalot/repos","events_url":"https://api.github.com/users/kowalot/events{/privacy}","received_events_url":"https://api.github.com/users/kowalot/received_events","type":"User","site_admin":false},"created_at":"2016-03-01T07:57:20Z","updated_at":"2016-03-01T07:57:20Z","body":"I did my tests on default configuration. I will let you know how it looks with/without compression."}}