{"action":"created","issue":{"url":"https://api.github.com/repos/Azure/azure-documentdb-node/issues/78","labels_url":"https://api.github.com/repos/Azure/azure-documentdb-node/issues/78/labels{/name}","comments_url":"https://api.github.com/repos/Azure/azure-documentdb-node/issues/78/comments","events_url":"https://api.github.com/repos/Azure/azure-documentdb-node/issues/78/events","html_url":"https://github.com/Azure/azure-documentdb-node/issues/78","id":109231869,"number":78,"title":"Support for Direct mode","user":{"login":"xtazz","id":97751,"avatar_url":"https://avatars.githubusercontent.com/u/97751?v=3","gravatar_id":"","url":"https://api.github.com/users/xtazz","html_url":"https://github.com/xtazz","followers_url":"https://api.github.com/users/xtazz/followers","following_url":"https://api.github.com/users/xtazz/following{/other_user}","gists_url":"https://api.github.com/users/xtazz/gists{/gist_id}","starred_url":"https://api.github.com/users/xtazz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xtazz/subscriptions","organizations_url":"https://api.github.com/users/xtazz/orgs","repos_url":"https://api.github.com/users/xtazz/repos","events_url":"https://api.github.com/users/xtazz/events{/privacy}","received_events_url":"https://api.github.com/users/xtazz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-10-01T05:29:33Z","updated_at":"2016-01-20T15:27:40Z","closed_at":null,"body":"It would be nice for DocumentDB Node.js SDK to support Direct mode via TCP to speed up communication with the DB. Thank you!"},"comment":{"url":"https://api.github.com/repos/Azure/azure-documentdb-node/issues/comments/173237764","html_url":"https://github.com/Azure/azure-documentdb-node/issues/78#issuecomment-173237764","issue_url":"https://api.github.com/repos/Azure/azure-documentdb-node/issues/78","id":173237764,"user":{"login":"Jacob-McKay","id":6945571,"avatar_url":"https://avatars.githubusercontent.com/u/6945571?v=3","gravatar_id":"","url":"https://api.github.com/users/Jacob-McKay","html_url":"https://github.com/Jacob-McKay","followers_url":"https://api.github.com/users/Jacob-McKay/followers","following_url":"https://api.github.com/users/Jacob-McKay/following{/other_user}","gists_url":"https://api.github.com/users/Jacob-McKay/gists{/gist_id}","starred_url":"https://api.github.com/users/Jacob-McKay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jacob-McKay/subscriptions","organizations_url":"https://api.github.com/users/Jacob-McKay/orgs","repos_url":"https://api.github.com/users/Jacob-McKay/repos","events_url":"https://api.github.com/users/Jacob-McKay/events{/privacy}","received_events_url":"https://api.github.com/users/Jacob-McKay/received_events","type":"User","site_admin":false},"created_at":"2016-01-20T15:27:40Z","updated_at":"2016-01-20T15:27:40Z","body":"I work with @danbucholtz  and can answer to how we're using documentDb.\r\n\r\nThe main killer we have is that it takes upwards of 4 seconds for some web requests to make it through our web app api to docDb and back.  The web calls that take this long are ones where we are retrieving full document lists, like \"select * from root\".  For instance it took 4.5 seconds to retrieve 1200 records (all the records in one of our collections).\r\n\r\nOur collections are S2\r\nOperations that return a large dataset are the ones I would say are performing badly\r\nOur application is deployed via Azure Web App service.  Previously, the DocDb and Web App were NOT in the same region.  Since moving them to the same region, we have seen significant performance improvements (it took our ~4s calls to ~3s calls).\r\n\r\nWe prototyped out a .NET client making the same calls via the direct mode (TCP, not HTTP) and saw further improvements in performance, which is why we would like to see TCP in for our node.js web app ass soon as possible.\r\n\r\nWe also fiddled around with the page size in the documentDb client, increasing it to 1000 gave us a slight performance increase as well.\r\n\r\nI have also noticed that queries like \"select r.id from root\" perform much better than \"select * from root\" so that is another tweak I'm thinking about making to our application, as we typically retrieve and act on whole documents for flexibility"}}