{"action":"created","issue":{"url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client/issues/269","repository_url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client","labels_url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client/issues/269/labels{/name}","comments_url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client/issues/269/comments","events_url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client/issues/269/events","html_url":"https://github.com/Azure/azure-mobile-apps-net-client/issues/269","id":194709251,"number":269,"title":"PullAsync always pulls the last row of a table even if there are not any updates","user":{"login":"kinex","id":11364599,"avatar_url":"https://avatars.githubusercontent.com/u/11364599?v=3","gravatar_id":"","url":"https://api.github.com/users/kinex","html_url":"https://github.com/kinex","followers_url":"https://api.github.com/users/kinex/followers","following_url":"https://api.github.com/users/kinex/following{/other_user}","gists_url":"https://api.github.com/users/kinex/gists{/gist_id}","starred_url":"https://api.github.com/users/kinex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kinex/subscriptions","organizations_url":"https://api.github.com/users/kinex/orgs","repos_url":"https://api.github.com/users/kinex/repos","events_url":"https://api.github.com/users/kinex/events{/privacy}","received_events_url":"https://api.github.com/users/kinex/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-12-09T22:10:06Z","updated_at":"2016-12-13T14:11:16Z","closed_at":"2016-12-12T21:03:05Z","body":"Based on my tests PullAsync seems to always pull the last row of a table even if there are not any table updates done (subscribed event \"StoreOperationCompletedEvent\" reports that a row was updated). If there are several rows in a table, only the last row is reported as \"updated\". This same issue happens with all tables in my database. I am worried about this issue because I guess it causes me unnecessary (Azure) costs and also triggers unnecessary UI refresh events in my app. \r\n\r\nI am using release 3.0.3."},"comment":{"url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client/issues/comments/266747809","html_url":"https://github.com/Azure/azure-mobile-apps-net-client/issues/269#issuecomment-266747809","issue_url":"https://api.github.com/repos/Azure/azure-mobile-apps-net-client/issues/269","id":266747809,"user":{"login":"Hangarspace","id":5887053,"avatar_url":"https://avatars.githubusercontent.com/u/5887053?v=3","gravatar_id":"","url":"https://api.github.com/users/Hangarspace","html_url":"https://github.com/Hangarspace","followers_url":"https://api.github.com/users/Hangarspace/followers","following_url":"https://api.github.com/users/Hangarspace/following{/other_user}","gists_url":"https://api.github.com/users/Hangarspace/gists{/gist_id}","starred_url":"https://api.github.com/users/Hangarspace/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Hangarspace/subscriptions","organizations_url":"https://api.github.com/users/Hangarspace/orgs","repos_url":"https://api.github.com/users/Hangarspace/repos","events_url":"https://api.github.com/users/Hangarspace/events{/privacy}","received_events_url":"https://api.github.com/users/Hangarspace/received_events","type":"User","site_admin":false},"created_at":"2016-12-13T14:11:16Z","updated_at":"2016-12-13T14:11:16Z","body":"It becomes an issue when hundreds or thousands of rows can be updated on the sql server very quickly. Then every time the app does a sync it pulls all this data for no reason. \r\n\r\nIn a business case whereby a days data for a mobile user is prepared overnight but they are required to regularly check for updates during the day then it can add up.\r\n\r\nWhilst azure may not charge, mobile service operators certainly do."}}
{"actor":{"display_login":"Hangarspace"}}