{"action":"created","issue":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/7606","labels_url":"https://api.github.com/repos/yiisoft/yii2/issues/7606/labels{/name}","comments_url":"https://api.github.com/repos/yiisoft/yii2/issues/7606/comments","events_url":"https://api.github.com/repos/yiisoft/yii2/issues/7606/events","html_url":"https://github.com/yiisoft/yii2/issues/7606","id":60123769,"number":7606,"title":"Add limit and offset support to ActiveRecord::updateAll().","user":{"login":"thinker-g","id":3844316,"avatar_url":"https://avatars.githubusercontent.com/u/3844316?v=3","gravatar_id":"","url":"https://api.github.com/users/thinker-g","html_url":"https://github.com/thinker-g","followers_url":"https://api.github.com/users/thinker-g/followers","following_url":"https://api.github.com/users/thinker-g/following{/other_user}","gists_url":"https://api.github.com/users/thinker-g/gists{/gist_id}","starred_url":"https://api.github.com/users/thinker-g/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thinker-g/subscriptions","organizations_url":"https://api.github.com/users/thinker-g/orgs","repos_url":"https://api.github.com/users/thinker-g/repos","events_url":"https://api.github.com/users/thinker-g/events{/privacy}","received_events_url":"https://api.github.com/users/thinker-g/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/yiisoft/yii2/labels/status:under%20discussion","name":"status:under discussion","color":"f7c6c7"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/yiisoft/yii2/milestones/9","html_url":"https://github.com/yiisoft/yii2/milestones/2.0.x","labels_url":"https://api.github.com/repos/yiisoft/yii2/milestones/9/labels","id":831720,"number":9,"title":"2.0.x","description":"","creator":{"login":"cebe","id":189796,"avatar_url":"https://avatars.githubusercontent.com/u/189796?v=3","gravatar_id":"","url":"https://api.github.com/users/cebe","html_url":"https://github.com/cebe","followers_url":"https://api.github.com/users/cebe/followers","following_url":"https://api.github.com/users/cebe/following{/other_user}","gists_url":"https://api.github.com/users/cebe/gists{/gist_id}","starred_url":"https://api.github.com/users/cebe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cebe/subscriptions","organizations_url":"https://api.github.com/users/cebe/orgs","repos_url":"https://api.github.com/users/cebe/repos","events_url":"https://api.github.com/users/cebe/events{/privacy}","received_events_url":"https://api.github.com/users/cebe/received_events","type":"User","site_admin":false},"open_issues":309,"closed_issues":2,"state":"open","created_at":"2014-10-19T13:49:45Z","updated_at":"2015-03-08T10:03:33Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-03-06T16:24:57Z","updated_at":"2015-03-08T15:17:52Z","closed_at":null,"body":"## Can we add limit and offset support to method ActiveRecord::updateAll()?\r\n\r\nI'm trying to use this method to update the table of an AR. However, besides the condition, there are too many rows to update. I want current process to update the table with condition like ['someCol' => null] AND only 500 rows each time. Then I can leave the rest rows to other processes. \r\n\r\nPlease let me know if this is possible or I'll have to use QueryBuilder to perform this operation.\r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/comments/77754931","html_url":"https://github.com/yiisoft/yii2/issues/7606#issuecomment-77754931","issue_url":"https://api.github.com/repos/yiisoft/yii2/issues/7606","id":77754931,"user":{"login":"thinker-g","id":3844316,"avatar_url":"https://avatars.githubusercontent.com/u/3844316?v=3","gravatar_id":"","url":"https://api.github.com/users/thinker-g","html_url":"https://github.com/thinker-g","followers_url":"https://api.github.com/users/thinker-g/followers","following_url":"https://api.github.com/users/thinker-g/following{/other_user}","gists_url":"https://api.github.com/users/thinker-g/gists{/gist_id}","starred_url":"https://api.github.com/users/thinker-g/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thinker-g/subscriptions","organizations_url":"https://api.github.com/users/thinker-g/orgs","repos_url":"https://api.github.com/users/thinker-g/repos","events_url":"https://api.github.com/users/thinker-g/events{/privacy}","received_events_url":"https://api.github.com/users/thinker-g/received_events","type":"User","site_admin":false},"created_at":"2015-03-08T15:17:52Z","updated_at":"2015-03-08T15:17:52Z","body":"Hi udivankin,\r\n\r\nThanks for the answer! \r\nThe issue is not on reading large amount of data. It's about a LOCK & UPDATE mechanism. Please refer to my comment above for details. \r\n\r\nRegards,\r\n"}}