{"action":"created","issue":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/25","labels_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/25/comments","events_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/25/events","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/pull/25","id":57038735,"number":25,"title":"Performance de la suppression des tâches","user":{"login":"orthagh","id":418844,"avatar_url":"https://avatars.githubusercontent.com/u/418844?v=3","gravatar_id":"","url":"https://api.github.com/users/orthagh","html_url":"https://github.com/orthagh","followers_url":"https://api.github.com/users/orthagh/followers","following_url":"https://api.github.com/users/orthagh/following{/other_user}","gists_url":"https://api.github.com/users/orthagh/gists{/gist_id}","starred_url":"https://api.github.com/users/orthagh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orthagh/subscriptions","organizations_url":"https://api.github.com/users/orthagh/orgs","repos_url":"https://api.github.com/users/orthagh/repos","events_url":"https://api.github.com/users/orthagh/events{/privacy}","received_events_url":"https://api.github.com/users/orthagh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-09T14:41:26Z","updated_at":"2015-06-02T08:40:07Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/pulls/25","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/pull/25","diff_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/pull/25.diff","patch_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/pull/25.patch"},"body":"Dans le cas de tâches régulières et fréquentes (ex : déploiement toutes les 10 min sur un ensemble de serveurs assez conséquent), le nombre de jobslogs, states et jobs augmente considérablement et le temps de suppression explose au choix le timeout du serveur ou le max de ram allouée à php.\r\n\r\nJe n'ai pas trouvé l’intérêt de supprimer en cascade via les fonctions delete() de chaque objets et de plus en cascade. L'historique n'est jamais affiché pour ces sous-objets.   \r\nUn delete sql comme proposé ici s'exécute en moins de 2s pour le même résultat.   \r\n\r\nMerci par avance."},"comment":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/comments/107865053","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/pull/25#issuecomment-107865053","issue_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/25","id":107865053,"user":{"login":"orthagh","id":418844,"avatar_url":"https://avatars.githubusercontent.com/u/418844?v=3","gravatar_id":"","url":"https://api.github.com/users/orthagh","html_url":"https://github.com/orthagh","followers_url":"https://api.github.com/users/orthagh/followers","following_url":"https://api.github.com/users/orthagh/following{/other_user}","gists_url":"https://api.github.com/users/orthagh/gists{/gist_id}","starred_url":"https://api.github.com/users/orthagh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orthagh/subscriptions","organizations_url":"https://api.github.com/users/orthagh/orgs","repos_url":"https://api.github.com/users/orthagh/repos","events_url":"https://api.github.com/users/orthagh/events{/privacy}","received_events_url":"https://api.github.com/users/orthagh/received_events","type":"User","site_admin":false},"created_at":"2015-06-02T08:40:07Z","updated_at":"2015-06-02T08:40:07Z","body":"Done"}}