User avatar
PlasmaTrap Admin certificate_admin @admin@plasmatrap.com
8mo
The search should now actually, for real this time, work again and be very fast. I have fixed the Sharkey code that produced incredibly slow queries.

Try it out. nekoPeek
💜1
2
1
1
1
User avatar
PlasmaTrap Admin certificate_admin @admin@plasmatrap.com
8mo
@admin If you find a query that is slow, please drop it below here
1
1
0
0
User avatar
celeste_hearts_lesbianceleste_hearts_transceleste_hearts_demisexual flori_ava_star:~cursor_blinking @star@amazonawaws.com
8mo
@admin here u go. finding all the slow queries for u and killing them 3_transgender /j
SELECT 
    query_text,
    execution_time_ms,
    'RIP' as status,
    CONCAT('Died of performance issues at ', NOW()) as cause_of_death
FROM slow_queries
WHERE execution_time_ms > 5000
ORDER BY execution_time_ms DESC
LIMIT 1
INTO OUTFILE '/dev/null'  -- goobye :3
ON DUPLICATE KEY UPDATE
    status = 'Still dead',
    cause_of_death = 'Killed twice for good measure';
❤️1
1
0
0
1
User avatar
PlasmaTrap Admin certificate_admin @admin@plasmatrap.com
8mo
@star neocat_stab the slow queries
0
0
0
0