{"action":"opened","issue":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4022","repository_url":"https://api.github.com/repos/Starcounter/Starcounter","labels_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4022/labels{/name}","comments_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4022/comments","events_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4022/events","html_url":"https://github.com/Starcounter/Starcounter/issues/4022","id":197843148,"number":4022,"title":"Starcounter As Queue","user":{"login":"mandatorySuicide","id":10337014,"avatar_url":"https://avatars.githubusercontent.com/u/10337014?v=3","gravatar_id":"","url":"https://api.github.com/users/mandatorySuicide","html_url":"https://github.com/mandatorySuicide","followers_url":"https://api.github.com/users/mandatorySuicide/followers","following_url":"https://api.github.com/users/mandatorySuicide/following{/other_user}","gists_url":"https://api.github.com/users/mandatorySuicide/gists{/gist_id}","starred_url":"https://api.github.com/users/mandatorySuicide/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mandatorySuicide/subscriptions","organizations_url":"https://api.github.com/users/mandatorySuicide/orgs","repos_url":"https://api.github.com/users/mandatorySuicide/repos","events_url":"https://api.github.com/users/mandatorySuicide/events{/privacy}","received_events_url":"https://api.github.com/users/mandatorySuicide/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-28T12:05:57Z","updated_at":"2016-12-28T12:05:57Z","closed_at":null,"body":"Can I use Starcounter as queue? Let me delineate my problem. \r\nPushing Into Queue : (Using a Starcounter Table as queue )\r\nThe data that I want to queue , I will keep an additional column with it named \"Unsynced\" , which will be set to false every time I  insert a new row. \r\n\r\nSeeking from queue:\r\nI will run a query with clause => where  Unsynced = false. There will be a scheduler that will run this query in every one hour and fetch bulk of data from queue.\r\n\r\nNext Job:\r\nThen I will serialize the result set and make a post call to my remote server. \r\n\r\nPopping from the queue:\r\nI will iterate through the result set pick items one by one and update Unsynced column to true. \r\n\r\nMy concern:\r\nOn an average 1000 rows is inserted at each second which makes ~1 million data is stored in one hour for which Unsynced is set to false. So I have to iterate through a list of 1 million data and update each  of them one by one. Will it be an efficient solution?Am I doing it right? How can I solve this problem using Starcounter? Is there any alternative in which I can use Starcounter as queue? Do you have any suggestion how can I solve this queuing problem? Is there any better approach?\r\n\r\nNote : I can make a rest call to my remote server every time I insert a new row instead of queuing them but I want to offload it from my current service and introduce some queue based mechanism to sync data between my current server and my new remote server. \r\n"}}
{"actor":{"display_login":"mandatorySuicide"}}