{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5265","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5265/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5265/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5265/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5265","id":114670508,"number":5265,"title":"How can I profile Graph API updates to the db?","user":{"login":"aag-tonesoft","id":15149606,"avatar_url":"https://avatars.githubusercontent.com/u/15149606?v=3","gravatar_id":"","url":"https://api.github.com/users/aag-tonesoft","html_url":"https://github.com/aag-tonesoft","followers_url":"https://api.github.com/users/aag-tonesoft/followers","following_url":"https://api.github.com/users/aag-tonesoft/following{/other_user}","gists_url":"https://api.github.com/users/aag-tonesoft/gists{/gist_id}","starred_url":"https://api.github.com/users/aag-tonesoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aag-tonesoft/subscriptions","organizations_url":"https://api.github.com/users/aag-tonesoft/orgs","repos_url":"https://api.github.com/users/aag-tonesoft/repos","events_url":"https://api.github.com/users/aag-tonesoft/events{/privacy}","received_events_url":"https://api.github.com/users/aag-tonesoft/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-11-02T19:48:07Z","updated_at":"2015-11-03T01:05:57Z","closed_at":null,"body":"We have some constant (in time) updates to the db, one every 30 seconds, that are getting very very very slow.  The thread doing the update to the graph model needs to find if vertices and edges exist and update or create new relationships.  For some reason the requests are getting very slow over time, how can I understand where the bottleneck is. There must be some logs or tools that can \"profile\" graph api updates.  The performance of the db updates is making us question if we can go into production with this database."},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/153208822","html_url":"https://github.com/orientechnologies/orientdb/issues/5265#issuecomment-153208822","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5265","id":153208822,"user":{"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},"created_at":"2015-11-03T01:05:57Z","updated_at":"2015-11-03T01:05:57Z","body":"@aag-tonesoft please use the Enterprise Edition (download it from the web site) and after a while you should see the most expensive queries. Also, if you have the SQL query, prefix it with EXPLAIN in studio to have profiling information."}}