{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8141","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8141/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8141/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8141/events","html_url":"https://github.com/orientechnologies/orientdb/issues/8141","id":302628935,"number":8141,"title":"orientDB 3.0.0RC1 has big performance drop in comtrast to 2.2.13","user":{"login":"hp1975","id":32117169,"avatar_url":"https://avatars1.githubusercontent.com/u/32117169?v=4","gravatar_id":"","url":"https://api.github.com/users/hp1975","html_url":"https://github.com/hp1975","followers_url":"https://api.github.com/users/hp1975/followers","following_url":"https://api.github.com/users/hp1975/following{/other_user}","gists_url":"https://api.github.com/users/hp1975/gists{/gist_id}","starred_url":"https://api.github.com/users/hp1975/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hp1975/subscriptions","organizations_url":"https://api.github.com/users/hp1975/orgs","repos_url":"https://api.github.com/users/hp1975/repos","events_url":"https://api.github.com/users/hp1975/events{/privacy}","received_events_url":"https://api.github.com/users/hp1975/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2018-03-06T09:43:52Z","updated_at":"2018-03-08T20:39:32Z","closed_at":null,"author_association":"NONE","body":"OS: Windows12\r\nJava SDK : 1.8\r\nOrientDB version :2.2.13 and 3.0.0.RC\r\n\r\nWhen I upgrade the db server from 2.2.13 to orientdb 3.0.0RC1, the result in below shows\r\n1.\tUpdate rate time consumption increase 20%\r\n2.\tRead and insert rate decrease 10~20 times. Which is big retrogress\r\n\r\n\r\n![image](https://user-images.githubusercontent.com/32117169/37025022-89bf5f82-2165-11e8-8398-2f9b3a9fc377.png)\r\n\r\n\r\nheapsize:2.2 GB;  heapmaxsize:7.1 GB;  heapFreesize:1.4 GB;  numCPUs:8;cpuFrequencyInHz:2400000000;physical Memory:total: 32767Mb free: 26550Mb;swap Memory:total: 37631Mb free: 8349Mb;\r\n\r\nMAM-TEST 8 CPU/32GB RAM 450 GB HD with Win2012R2"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/371617014","html_url":"https://github.com/orientechnologies/orientdb/issues/8141#issuecomment-371617014","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8141","id":371617014,"user":{"login":"lvca","id":312606,"avatar_url":"https://avatars0.githubusercontent.com/u/312606?v=4","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},"created_at":"2018-03-08T20:39:32Z","updated_at":"2018-03-08T20:39:32Z","author_association":"OWNER","body":"My suspects are correct. With v3.0 everytime you execute a query, the open transaction is flushed to the server (to have the right consistency level).\r\n\r\n@tglman does make any sense to introduce something like `OTransaction.flushOnCommand(boolean)` to disable this behavior from the user? Or, even better, playing with the consistency level already in OTransaction:\r\n\r\n```\r\n  enum ISOLATION_LEVEL {\r\n    READ_COMMITTED, REPEATABLE_READ\r\n  }\r\n```\r\n\r\n?"}}
{"actor":{"display_login":"lvca"}}