{"action":"created","issue":{"url":"https://api.github.com/repos/OCA/social/issues/298","repository_url":"https://api.github.com/repos/OCA/social","labels_url":"https://api.github.com/repos/OCA/social/issues/298/labels{/name}","comments_url":"https://api.github.com/repos/OCA/social/issues/298/comments","events_url":"https://api.github.com/repos/OCA/social/issues/298/events","html_url":"https://github.com/OCA/social/issues/298","id":356554776,"node_id":"MDU6SXNzdWUzNTY1NTQ3NzY=","number":298,"title":"[11.0] mail_tracking: compute email_score field take a lot of time when partner has a lot of mail.tracking.email records","user":{"login":"zaoral","id":7593953,"node_id":"MDQ6VXNlcjc1OTM5NTM=","avatar_url":"https://avatars0.githubusercontent.com/u/7593953?v=4","gravatar_id":"","url":"https://api.github.com/users/zaoral","html_url":"https://github.com/zaoral","followers_url":"https://api.github.com/users/zaoral/followers","following_url":"https://api.github.com/users/zaoral/following{/other_user}","gists_url":"https://api.github.com/users/zaoral/gists{/gist_id}","starred_url":"https://api.github.com/users/zaoral/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zaoral/subscriptions","organizations_url":"https://api.github.com/users/zaoral/orgs","repos_url":"https://api.github.com/users/zaoral/repos","events_url":"https://api.github.com/users/zaoral/events{/privacy}","received_events_url":"https://api.github.com/users/zaoral/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-09-03T16:03:54Z","updated_at":"2018-09-06T18:06:48Z","closed_at":"2018-09-06T09:24:36Z","author_association":"NONE","body":"This is happening for the change made in email_is_bounced and email_score_from_email methods,\r\nin version 9.0 we were filtering the last 10 records, while in version 11.0 we are searching in all the \"mail.tracking.email\" records. Visual diff bellow.\r\n\r\nDoes we need actually search in all the mail.tracking.email that exists? Maybe we could filter the last N records making N customizable by the admin user. Or have a ir.cron that clean  the records that we are not consulting since they are very old.\r\n\r\n![diff-9-11-mail_tracking](https://user-images.githubusercontent.com/7593953/44995247-a2f98d00-af78-11e8-8f5a-7039c4bd8fd1.png)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/OCA/social/issues/comments/419189100","html_url":"https://github.com/OCA/social/issues/298#issuecomment-419189100","issue_url":"https://api.github.com/repos/OCA/social/issues/298","id":419189100,"node_id":"MDEyOklzc3VlQ29tbWVudDQxOTE4OTEwMA==","user":{"login":"zaoral","id":7593953,"node_id":"MDQ6VXNlcjc1OTM5NTM=","avatar_url":"https://avatars0.githubusercontent.com/u/7593953?v=4","gravatar_id":"","url":"https://api.github.com/users/zaoral","html_url":"https://github.com/zaoral","followers_url":"https://api.github.com/users/zaoral/followers","following_url":"https://api.github.com/users/zaoral/following{/other_user}","gists_url":"https://api.github.com/users/zaoral/gists{/gist_id}","starred_url":"https://api.github.com/users/zaoral/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zaoral/subscriptions","organizations_url":"https://api.github.com/users/zaoral/orgs","repos_url":"https://api.github.com/users/zaoral/repos","events_url":"https://api.github.com/users/zaoral/events{/privacy}","received_events_url":"https://api.github.com/users/zaoral/received_events","type":"User","site_admin":false},"created_at":"2018-09-06T18:06:48Z","updated_at":"2018-09-06T18:06:48Z","author_association":"NONE","body":"Thank you @chienandalu @pedrobaeza \r\n\r\nI have tested with the fix you suggest/made and works.\r\nNow it takes 83% less of time to compute email score.\r\n\r\nBest Regards"}}
{"actor":{"display_login":"zaoral"}}