{"action":"created","issue":{"url":"https://api.github.com/repos/dotnet/roslyn/issues/30306","repository_url":"https://api.github.com/repos/dotnet/roslyn","labels_url":"https://api.github.com/repos/dotnet/roslyn/issues/30306/labels{/name}","comments_url":"https://api.github.com/repos/dotnet/roslyn/issues/30306/comments","events_url":"https://api.github.com/repos/dotnet/roslyn/issues/30306/events","html_url":"https://github.com/dotnet/roslyn/issues/30306","id":366587566,"node_id":"MDU6SXNzdWUzNjY1ODc1NjY=","number":30306,"title":"improve Sqlite reading perf","user":{"login":"heejaechang","id":1333179,"node_id":"MDQ6VXNlcjEzMzMxNzk=","avatar_url":"https://avatars3.githubusercontent.com/u/1333179?v=4","gravatar_id":"","url":"https://api.github.com/users/heejaechang","html_url":"https://github.com/heejaechang","followers_url":"https://api.github.com/users/heejaechang/followers","following_url":"https://api.github.com/users/heejaechang/following{/other_user}","gists_url":"https://api.github.com/users/heejaechang/gists{/gist_id}","starred_url":"https://api.github.com/users/heejaechang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/heejaechang/subscriptions","organizations_url":"https://api.github.com/users/heejaechang/orgs","repos_url":"https://api.github.com/users/heejaechang/repos","events_url":"https://api.github.com/users/heejaechang/events{/privacy}","received_events_url":"https://api.github.com/users/heejaechang/received_events","type":"User","site_admin":false},"labels":[{"id":166377917,"node_id":"MDU6TGFiZWwxNjYzNzc5MTc=","url":"https://api.github.com/repos/dotnet/roslyn/labels/Area-IDE","name":"Area-IDE","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":12,"created_at":"2018-10-04T01:22:49Z","updated_at":"2018-10-04T04:42:28Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Current implementation of sqlite persistent storage always read full data before returning stream.\r\n\r\nbut the way we use this data is almost always checking some header from it and drop the stream if data is out of date.\r\n\r\nwe can either change the persistent interface to have some kind of version stuff to make this pattern more official and more efficient by not reading unnecessary blobs or make sqlite to lazily read data and fill stream as it gets consumed.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/dotnet/roslyn/issues/comments/426883455","html_url":"https://github.com/dotnet/roslyn/issues/30306#issuecomment-426883455","issue_url":"https://api.github.com/repos/dotnet/roslyn/issues/30306","id":426883455,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNjg4MzQ1NQ==","user":{"login":"CyrusNajmabadi","id":4564579,"node_id":"MDQ6VXNlcjQ1NjQ1Nzk=","avatar_url":"https://avatars3.githubusercontent.com/u/4564579?v=4","gravatar_id":"","url":"https://api.github.com/users/CyrusNajmabadi","html_url":"https://github.com/CyrusNajmabadi","followers_url":"https://api.github.com/users/CyrusNajmabadi/followers","following_url":"https://api.github.com/users/CyrusNajmabadi/following{/other_user}","gists_url":"https://api.github.com/users/CyrusNajmabadi/gists{/gist_id}","starred_url":"https://api.github.com/users/CyrusNajmabadi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CyrusNajmabadi/subscriptions","organizations_url":"https://api.github.com/users/CyrusNajmabadi/orgs","repos_url":"https://api.github.com/users/CyrusNajmabadi/repos","events_url":"https://api.github.com/users/CyrusNajmabadi/events{/privacy}","received_events_url":"https://api.github.com/users/CyrusNajmabadi/received_events","type":"User","site_admin":false},"created_at":"2018-10-04T04:42:28Z","updated_at":"2018-10-04T04:42:28Z","author_association":"CONTRIBUTOR","body":"> but I want all of the persistent service consumers to use a new pattern as well so that they don't need to read whole data just to check versions.\r\n\r\nIf they're jsut checking versions... they can use the form i just specified.  i.e. there can be a small blob of data that is the checksum/version and which can easily be read independently of the main bulk of hte data..."}}
{"actor":{"display_login":"CyrusNajmabadi"}}