{"action":"created","issue":{"url":"https://api.github.com/repos/AlexKue/SWEP/issues/38","repository_url":"https://api.github.com/repos/AlexKue/SWEP","labels_url":"https://api.github.com/repos/AlexKue/SWEP/issues/38/labels{/name}","comments_url":"https://api.github.com/repos/AlexKue/SWEP/issues/38/comments","events_url":"https://api.github.com/repos/AlexKue/SWEP/issues/38/events","html_url":"https://github.com/AlexKue/SWEP/issues/38","id":465720847,"node_id":"MDU6SXNzdWU0NjU3MjA4NDc=","number":38,"title":"Server Terminiert nicht bei zu langer SQL Anfrage","user":{"login":"MisterDerpie","id":34041141,"node_id":"MDQ6VXNlcjM0MDQxMTQx","avatar_url":"https://avatars2.githubusercontent.com/u/34041141?v=4","gravatar_id":"","url":"https://api.github.com/users/MisterDerpie","html_url":"https://github.com/MisterDerpie","followers_url":"https://api.github.com/users/MisterDerpie/followers","following_url":"https://api.github.com/users/MisterDerpie/following{/other_user}","gists_url":"https://api.github.com/users/MisterDerpie/gists{/gist_id}","starred_url":"https://api.github.com/users/MisterDerpie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MisterDerpie/subscriptions","organizations_url":"https://api.github.com/users/MisterDerpie/orgs","repos_url":"https://api.github.com/users/MisterDerpie/repos","events_url":"https://api.github.com/users/MisterDerpie/events{/privacy}","received_events_url":"https://api.github.com/users/MisterDerpie/received_events","type":"User","site_admin":false},"labels":[{"id":1342622405,"node_id":"MDU6TGFiZWwxMzQyNjIyNDA1","url":"https://api.github.com/repos/AlexKue/SWEP/labels/bug","name":"bug","color":"d73a4a","default":true},{"id":1428679949,"node_id":"MDU6TGFiZWwxNDI4Njc5OTQ5","url":"https://api.github.com/repos/AlexKue/SWEP/labels/important","name":"important","color":"aa172b","default":false}],"state":"open","locked":false,"assignee":{"login":"AlexKue","id":17688565,"node_id":"MDQ6VXNlcjE3Njg4NTY1","avatar_url":"https://avatars0.githubusercontent.com/u/17688565?v=4","gravatar_id":"","url":"https://api.github.com/users/AlexKue","html_url":"https://github.com/AlexKue","followers_url":"https://api.github.com/users/AlexKue/followers","following_url":"https://api.github.com/users/AlexKue/following{/other_user}","gists_url":"https://api.github.com/users/AlexKue/gists{/gist_id}","starred_url":"https://api.github.com/users/AlexKue/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlexKue/subscriptions","organizations_url":"https://api.github.com/users/AlexKue/orgs","repos_url":"https://api.github.com/users/AlexKue/repos","events_url":"https://api.github.com/users/AlexKue/events{/privacy}","received_events_url":"https://api.github.com/users/AlexKue/received_events","type":"User","site_admin":false},"assignees":[{"login":"AlexKue","id":17688565,"node_id":"MDQ6VXNlcjE3Njg4NTY1","avatar_url":"https://avatars0.githubusercontent.com/u/17688565?v=4","gravatar_id":"","url":"https://api.github.com/users/AlexKue","html_url":"https://github.com/AlexKue","followers_url":"https://api.github.com/users/AlexKue/followers","following_url":"https://api.github.com/users/AlexKue/following{/other_user}","gists_url":"https://api.github.com/users/AlexKue/gists{/gist_id}","starred_url":"https://api.github.com/users/AlexKue/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlexKue/subscriptions","organizations_url":"https://api.github.com/users/AlexKue/orgs","repos_url":"https://api.github.com/users/AlexKue/repos","events_url":"https://api.github.com/users/AlexKue/events{/privacy}","received_events_url":"https://api.github.com/users/AlexKue/received_events","type":"User","site_admin":false},{"login":"merkrafter","id":20241185,"node_id":"MDQ6VXNlcjIwMjQxMTg1","avatar_url":"https://avatars1.githubusercontent.com/u/20241185?v=4","gravatar_id":"","url":"https://api.github.com/users/merkrafter","html_url":"https://github.com/merkrafter","followers_url":"https://api.github.com/users/merkrafter/followers","following_url":"https://api.github.com/users/merkrafter/following{/other_user}","gists_url":"https://api.github.com/users/merkrafter/gists{/gist_id}","starred_url":"https://api.github.com/users/merkrafter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/merkrafter/subscriptions","organizations_url":"https://api.github.com/users/merkrafter/orgs","repos_url":"https://api.github.com/users/merkrafter/repos","events_url":"https://api.github.com/users/merkrafter/events{/privacy}","received_events_url":"https://api.github.com/users/merkrafter/received_events","type":"User","site_admin":false},{"login":"MisterDerpie","id":34041141,"node_id":"MDQ6VXNlcjM0MDQxMTQx","avatar_url":"https://avatars2.githubusercontent.com/u/34041141?v=4","gravatar_id":"","url":"https://api.github.com/users/MisterDerpie","html_url":"https://github.com/MisterDerpie","followers_url":"https://api.github.com/users/MisterDerpie/followers","following_url":"https://api.github.com/users/MisterDerpie/following{/other_user}","gists_url":"https://api.github.com/users/MisterDerpie/gists{/gist_id}","starred_url":"https://api.github.com/users/MisterDerpie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MisterDerpie/subscriptions","organizations_url":"https://api.github.com/users/MisterDerpie/orgs","repos_url":"https://api.github.com/users/MisterDerpie/repos","events_url":"https://api.github.com/users/MisterDerpie/events{/privacy}","received_events_url":"https://api.github.com/users/MisterDerpie/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/AlexKue/SWEP/milestones/2","html_url":"https://github.com/AlexKue/SWEP/milestone/2","labels_url":"https://api.github.com/repos/AlexKue/SWEP/milestones/2/labels","id":4380956,"node_id":"MDk6TWlsZXN0b25lNDM4MDk1Ng==","number":2,"title":"MVP","description":"Das Minimum Viable Product umfasst im Wesentlichen das Erstellen, Bearbeiten und Bewerten von Aufgaben.","creator":{"login":"merkrafter","id":20241185,"node_id":"MDQ6VXNlcjIwMjQxMTg1","avatar_url":"https://avatars1.githubusercontent.com/u/20241185?v=4","gravatar_id":"","url":"https://api.github.com/users/merkrafter","html_url":"https://github.com/merkrafter","followers_url":"https://api.github.com/users/merkrafter/followers","following_url":"https://api.github.com/users/merkrafter/following{/other_user}","gists_url":"https://api.github.com/users/merkrafter/gists{/gist_id}","starred_url":"https://api.github.com/users/merkrafter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/merkrafter/subscriptions","organizations_url":"https://api.github.com/users/merkrafter/orgs","repos_url":"https://api.github.com/users/merkrafter/repos","events_url":"https://api.github.com/users/merkrafter/events{/privacy}","received_events_url":"https://api.github.com/users/merkrafter/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":21,"state":"open","created_at":"2019-06-05T19:47:36Z","updated_at":"2019-07-09T17:40:24Z","due_on":"2019-06-26T07:00:00Z","closed_at":null},"comments":6,"created_at":"2019-07-09T11:13:59Z","updated_at":"2019-07-09T21:31:06Z","closed_at":null,"author_association":"COLLABORATOR","body":"In der Spielwiese die folgende Query\r\n`SELECT * FROM studenten S, professoren P, vorlesungen V, assistenten A where S.semester > 0 or P.persnr > 0 or V.vorlnr > 0 or A.persnr > 0`\r\ntesten. Es läuft deutlich länger als 5 Sekunden.\r\n\r\nTestumgebung: Die aufgesetzte Website von @AlexKue "},"comment":{"url":"https://api.github.com/repos/AlexKue/SWEP/issues/comments/509817260","html_url":"https://github.com/AlexKue/SWEP/issues/38#issuecomment-509817260","issue_url":"https://api.github.com/repos/AlexKue/SWEP/issues/38","id":509817260,"node_id":"MDEyOklzc3VlQ29tbWVudDUwOTgxNzI2MA==","user":{"login":"merkrafter","id":20241185,"node_id":"MDQ6VXNlcjIwMjQxMTg1","avatar_url":"https://avatars1.githubusercontent.com/u/20241185?v=4","gravatar_id":"","url":"https://api.github.com/users/merkrafter","html_url":"https://github.com/merkrafter","followers_url":"https://api.github.com/users/merkrafter/followers","following_url":"https://api.github.com/users/merkrafter/following{/other_user}","gists_url":"https://api.github.com/users/merkrafter/gists{/gist_id}","starred_url":"https://api.github.com/users/merkrafter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/merkrafter/subscriptions","organizations_url":"https://api.github.com/users/merkrafter/orgs","repos_url":"https://api.github.com/users/merkrafter/repos","events_url":"https://api.github.com/users/merkrafter/events{/privacy}","received_events_url":"https://api.github.com/users/merkrafter/received_events","type":"User","site_admin":false},"created_at":"2019-07-09T21:31:06Z","updated_at":"2019-07-09T21:31:06Z","author_association":"COLLABORATOR","body":"Commit c62687c behebt die quälend lange Ausführungszeit zumindest serverseitig.\r\nDer Aufwand kam dadurch, dass die entsprechende Methode noch aus der Zeit stammte, als die Datenbank noch nicht direkt angesprochen werden konnte, sondern nur, indem man eine Query mit sich selbst validierte. Bei den > 3000 Zeilen dieser Query durchaus ein unnötig großer Aufwand."}}
{"actor":{"display_login":"merkrafter"}}