{"generator":"StatusNet 1.1.1-release","title":"Unterhaltung","totalItems":4,"items":[{"actor":{"displayName":"xrevan86","id":"https:\/\/loadaverage.org\/user\/124","status_net":{"avatarLinks":[{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-48-20180114011857.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"http:\/\/sn.1w6.org\/avatar\/382-24-20180114011857.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"382"}},"image":{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","url":"https:\/\/loadaverage.org\/xrevan86","location":{"objectType":"place","position":"+1.28967+103.85007\/","lat":"1.28967","lon":"103.85007"},"portablecontacts_net":{"preferredUsername":"xrevan86","displayName":"xrevan86","note":"A Russophone, a maintainer at openSUSE, an atheist, a socialist (pro social justice). I don't know what I'm doing, but I try my best anyway.","addresses":{"formatted":"Leningrad, RSFSR"},"urls":[{"type":"homepage","value":"https:\/\/revan.ttyh.ru\/","primary":"true"}]}},"content":"@<a href=\"https:\/\/community.highlandarrow.com\/user\/1\" class=\"h-card u-url p-nickname mention\" title=\"Annah\">maiyannah<\/a> Recently I've once again become disappointed with how this SQL query performs on !<a href=\"https:\/\/loadaverage.org\/group\/1\/id\" class=\"h-card u-url p-nickname group\" title=\"LoadAverage.org instance (loadaverage)\">loadaverage<\/a>, so I looked at it with a fresh eye, as a result <a href=\"https:\/\/notabug.org\/diogo\/gnu-social\/commit\/6b5450b7\" title=\"https:\/\/notabug.org\/diogo\/gnu-social\/commit\/6b5450b7\" rel=\"nofollow noreferrer\" class=\"attachment\">https:\/\/notabug.org\/diogo\/gnu-social\/commit\/6b5450b7<\/a> was born.<br \/> Must be good for postActiv as well :-).","generator":{"displayName":"ostatus","id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"tag:sn.1w6.org,2026-07-31:post:257202","object":{"id":"tag:loadaverage.org,2019-04-25:noticeId=16371730:objectType=note","objectType":"comment","content":"@<a href=\"https:\/\/community.highlandarrow.com\/user\/1\" class=\"h-card u-url p-nickname mention\" title=\"Annah\">maiyannah<\/a> Recently I've once again become disappointed with how this SQL query performs on !<a href=\"https:\/\/loadaverage.org\/group\/1\/id\" class=\"h-card u-url p-nickname group\" title=\"LoadAverage.org instance (loadaverage)\">loadaverage<\/a>, so I looked at it with a fresh eye, as a result <a href=\"https:\/\/notabug.org\/diogo\/gnu-social\/commit\/6b5450b7\" title=\"https:\/\/notabug.org\/diogo\/gnu-social\/commit\/6b5450b7\" rel=\"nofollow noreferrer\" class=\"attachment\">https:\/\/notabug.org\/diogo\/gnu-social\/commit\/6b5450b7<\/a> was born.<br \/> Must be good for postActiv as well :-).","url":"https:\/\/loadaverage.org\/notice\/16371730","status_net":{"notice_id":"257202"},"inReplyTo":{"objectType":"note","id":"tag:loadaverage.org,2018-03-22:noticeId=12148389:objectType=note","url":"https:\/\/loadaverage.org\/notice\/12148389"}},"to":[{"objectType":"person","id":"https:\/\/loadaverage.org\/user\/124"},{"objectType":"person","id":"https:\/\/community.highlandarrow.com\/user\/1"},{"objectType":"group","id":"https:\/\/loadaverage.org\/group\/1\/id"},{"objectType":"collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"http:\/\/sn.1w6.org\/conversation\/207787","notice_info":{"local_id":"257202","source":"ostatus"}},"published":"2019-04-25T18:41:02+00:00","provider":{"objectType":"service","displayName":"1w6 uRPG","url":"http:\/\/sn.1w6.org\/"},"verb":"post"},{"actor":{"displayName":"xrevan86","id":"https:\/\/loadaverage.org\/user\/124","status_net":{"avatarLinks":[{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-48-20180114011857.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"http:\/\/sn.1w6.org\/avatar\/382-24-20180114011857.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"382"}},"image":{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","url":"https:\/\/loadaverage.org\/xrevan86","location":{"objectType":"place","position":"+1.28967+103.85007\/","lat":"1.28967","lon":"103.85007"},"portablecontacts_net":{"preferredUsername":"xrevan86","displayName":"xrevan86","note":"A Russophone, a maintainer at openSUSE, an atheist, a socialist (pro social justice). I don't know what I'm doing, but I try my best anyway.","addresses":{"formatted":"Leningrad, RSFSR"},"urls":[{"type":"homepage","value":"https:\/\/revan.ttyh.ru\/","primary":"true"}]}},"content":"@<a href=\"https:\/\/community.highlandarrow.com\/user\/1\" class=\"h-card u-url p-nickname mention\" title=\"Maiyannah Bishop\">maiyannah<\/a> As a downside, the generated queries can be extremely long (like 40 000 symbols), yet, for some reason, that works significantly better than what was before still.","generator":{"displayName":"ostatus","id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"tag:sn.1w6.org,2026-07-31:post:246544","object":{"id":"tag:loadaverage.org,2018-03-22:noticeId=12148419:objectType=note","objectType":"comment","content":"@<a href=\"https:\/\/community.highlandarrow.com\/user\/1\" class=\"h-card u-url p-nickname mention\" title=\"Maiyannah Bishop\">maiyannah<\/a> As a downside, the generated queries can be extremely long (like 40 000 symbols), yet, for some reason, that works significantly better than what was before still.","url":"https:\/\/loadaverage.org\/notice\/12148419","status_net":{"notice_id":"246544"},"inReplyTo":{"objectType":"note","id":"tag:loadaverage.org,2018-03-22:noticeId=12148389:objectType=note","url":"https:\/\/loadaverage.org\/notice\/12148389"}},"to":[{"objectType":"person","id":"https:\/\/loadaverage.org\/user\/124"},{"objectType":"person","id":"https:\/\/community.highlandarrow.com\/user\/1"},{"objectType":"collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"http:\/\/sn.1w6.org\/conversation\/207787","notice_info":{"local_id":"246544","source":"ostatus"}},"published":"2018-03-22T17:45:14+00:00","provider":{"objectType":"service","displayName":"1w6 uRPG","url":"http:\/\/sn.1w6.org\/"},"verb":"post"},{"actor":{"displayName":"xrevan86","id":"https:\/\/loadaverage.org\/user\/124","status_net":{"avatarLinks":[{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-48-20180114011857.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"http:\/\/sn.1w6.org\/avatar\/382-24-20180114011857.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"382"}},"image":{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","url":"https:\/\/loadaverage.org\/xrevan86","location":{"objectType":"place","position":"+1.28967+103.85007\/","lat":"1.28967","lon":"103.85007"},"portablecontacts_net":{"preferredUsername":"xrevan86","displayName":"xrevan86","note":"A Russophone, a maintainer at openSUSE, an atheist, a socialist (pro social justice). I don't know what I'm doing, but I try my best anyway.","addresses":{"formatted":"Leningrad, RSFSR"},"urls":[{"type":"homepage","value":"https:\/\/revan.ttyh.ru\/","primary":"true"}]}},"content":"@<a href=\"https:\/\/community.highlandarrow.com\/user\/1\" class=\"h-card u-url p-nickname mention\" title=\"Maiyannah Bishop\">maiyannah<\/a> I have it: <a href=\"https:\/\/paste.debian.net\/hidden\/4d11a11d\" title=\"https:\/\/paste.debian.net\/hidden\/4d11a11d\" rel=\"nofollow noreferrer\" class=\"attachment\">https:\/\/paste.debian.net\/hidden\/4d11a11d<\/a> (and it is applied on !<a href=\"https:\/\/loadaverage.org\/group\/1\/id\" class=\"h-card u-url p-nickname group\" title=\"LoadAverage.org instance (loadaverage)\">loadaverage<\/a>)!<br \/> And yes, this really does help with performance :-).","generator":{"displayName":"ostatus","id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"tag:sn.1w6.org,2026-07-31:post:246539","object":{"id":"tag:loadaverage.org,2018-03-22:noticeId=12148389:objectType=note","objectType":"comment","content":"@<a href=\"https:\/\/community.highlandarrow.com\/user\/1\" class=\"h-card u-url p-nickname mention\" title=\"Maiyannah Bishop\">maiyannah<\/a> I have it: <a href=\"https:\/\/paste.debian.net\/hidden\/4d11a11d\" title=\"https:\/\/paste.debian.net\/hidden\/4d11a11d\" rel=\"nofollow noreferrer\" class=\"attachment\">https:\/\/paste.debian.net\/hidden\/4d11a11d<\/a> (and it is applied on !<a href=\"https:\/\/loadaverage.org\/group\/1\/id\" class=\"h-card u-url p-nickname group\" title=\"LoadAverage.org instance (loadaverage)\">loadaverage<\/a>)!<br \/> And yes, this really does help with performance :-).","url":"https:\/\/loadaverage.org\/notice\/12148389","status_net":{"notice_id":"246539"},"inReplyTo":{"objectType":"note","id":"tag:loadaverage.org,2018-02-10:noticeId=11778054:objectType=note","url":"https:\/\/loadaverage.org\/notice\/11778054"}},"to":[{"objectType":"person","id":"https:\/\/loadaverage.org\/user\/124"},{"objectType":"person","id":"https:\/\/community.highlandarrow.com\/user\/1"},{"objectType":"group","id":"https:\/\/loadaverage.org\/group\/1\/id"},{"objectType":"collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"http:\/\/sn.1w6.org\/conversation\/207787","notice_info":{"local_id":"246539","source":"ostatus"}},"published":"2018-03-22T17:40:54+00:00","provider":{"objectType":"service","displayName":"1w6 uRPG","url":"http:\/\/sn.1w6.org\/"},"verb":"post"},{"actor":{"displayName":"xrevan86","id":"https:\/\/loadaverage.org\/user\/124","status_net":{"avatarLinks":[{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"http:\/\/sn.1w6.org\/avatar\/382-48-20180114011857.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"http:\/\/sn.1w6.org\/avatar\/382-24-20180114011857.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"382"}},"image":{"url":"http:\/\/sn.1w6.org\/avatar\/382-original-20180114011856.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","url":"https:\/\/loadaverage.org\/xrevan86","location":{"objectType":"place","position":"+1.28967+103.85007\/","lat":"1.28967","lon":"103.85007"},"portablecontacts_net":{"preferredUsername":"xrevan86","displayName":"xrevan86","note":"A Russophone, a maintainer at openSUSE, an atheist, a socialist (pro social justice). I don't know what I'm doing, but I try my best anyway.","addresses":{"formatted":"Leningrad, RSFSR"},"urls":[{"type":"homepage","value":"https:\/\/revan.ttyh.ru\/","primary":"true"}]}},"content":"@maiyannah In the end I don't think I succeeded in my attempts at optimising the SELECT at lib\/inboxnoticestream.php. But on !loadaverage another thing actually did get a good result: the Compressed raw format on the &quot;notice&quot; table. Seems <a href=\"http:\/\/sn.1w6.org\/attachment\/21264\" class=\"attachment more\" title=\"Mehr anzeigen\">&#8230;<\/a>","generator":{"displayName":"ostatus","id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"tag:sn.1w6.org,2026-07-31:post:240654","object":{"id":"tag:loadaverage.org,2018-02-10:noticeId=11778054:objectType=note","objectType":"note","content":"@maiyannah In the end I don't think I succeeded in my attempts at optimising the SELECT at lib\/inboxnoticestream.php. But on !loadaverage another thing actually did get a good result: the Compressed raw format on the &quot;notice&quot; table. Seems <a href=\"http:\/\/sn.1w6.org\/attachment\/21264\" class=\"attachment more\" title=\"Mehr anzeigen\">&#8230;<\/a>","url":"https:\/\/loadaverage.org\/notice\/11778054","status_net":{"notice_id":"240654"},"attachments":[{"id":"tag:sn.1w6.org,2026-07-31:file:21264","objectType":"file","url":"http:\/\/sn.1w6.org\/attachment\/21264"}]},"to":[{"objectType":"person","id":"https:\/\/community.highlandarrow.com\/user\/1"},{"objectType":"group","id":"https:\/\/loadaverage.org\/group\/1\/id"},{"objectType":"collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"http:\/\/sn.1w6.org\/conversation\/207787","notice_info":{"local_id":"240654","source":"ostatus"}},"published":"2018-02-10T00:10:13+00:00","provider":{"objectType":"service","displayName":"1w6 uRPG","url":"http:\/\/sn.1w6.org\/"},"verb":"post"}],"links":[{"url":"http:\/\/sn.1w6.org\/conversation\/207787","rel":"alternate","type":"text\/html"}]}