Zankaria
1 follower · 1 following
  • Joined on 2025-02-18
Repositories Projects Packages Public activity Starred repositories
1
Zankaria commented on pull request leftypol/leftypol#134 2025-07-12 18:04:29 -05:00
Fix high CPU usage with overboard's catalog

So, mariadb doesn't seem to support in subqueries all the things that speed up the query...

Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-12 17:49:47 -05:00
e73ba1cb57 catalog: subquery ORDER BY is useless without LIMIT
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-11 17:40:59 -05:00
4adfa4faaf catalg: mariadb does not support LIMIT inside subqueries
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-11 17:08:43 -05:00
ec85705fb2 catalog: work around php being php
a2333b866e config: fix overboard query generation, subqueries could not sort posts before being cut by the limit
57e13765ab catalog: improve overboard SQL generation
3b43233caa config: rework query (still be perdedora)
02843713e2 catalog: fix SQL query sintax
Compare 8 commits »
Zankaria pushed to config at leftypol/leftypol 2025-07-11 17:08:22 -05:00
cef13f0b31 config.php: increase the default search max weight
28ce41dedc SearchService.php: prettier weight logging
Compare 2 commits »
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-11 17:04:45 -05:00
3db5c3c094 catalog: work around php being php
a7a909e40a config: fix overboard query generation, subqueries could not sort posts before being cut by the limit
572ce70f53 catalog: improve overboard SQL generation
f81f1d650e config: rework query (still be perdedora)
ceff861373 catalog: fix SQL query sintax
Compare 37 commits »
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-11 16:51:55 -05:00
a0c44eeb08 catalog: work around php being php
Zankaria opened issue leftypol/leftypol#136 2025-07-08 16:57:29 -05:00
Broad search is too broad
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-08 16:44:45 -05:00
a37e3857af config: fix overboard query generation, subqueries could not sort posts before being cut by the limit
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-08 16:32:18 -05:00
b7821ce690 catalog: improve overboard SQL generation
Zankaria opened issue leftypol/leftypol#135 2025-07-08 16:00:50 -05:00
Fix search flag filter
Zankaria pushed to config at leftypol/leftypol 2025-07-08 14:38:28 -05:00
1767c7b316 UserPostQueries.php: fix post search ordering
Zankaria pushed to config at leftypol/leftypol 2025-07-08 14:31:50 -05:00
360161b1fc SearchService.php: handle filters getting trimmed into oblivion
Zankaria pushed to config at leftypol/leftypol 2025-07-08 14:29:11 -05:00
49d57920bc SearchService.php: handle filters getting trimmed into oblivion
Zankaria pushed to config at leftypol/leftypol 2025-07-08 14:18:22 -05:00
75ce687af5 SearchService.php: fix search detecting spurious flags
Zankaria pushed to config at leftypol/leftypol 2025-07-08 14:09:28 -05:00
8028c1bd9a context.php: handle the search.flag_filter configuration option
d695ff2582 config.php: add flag_filter option, off by default
Compare 2 commits »
Zankaria pushed to config at leftypol/leftypol 2025-07-08 13:59:55 -05:00
6e9d0a4e77 Merge pull request 'Refactor the search subsystem' (#127) from rework-search into config
26ad13bbea search_form.html: make the search for UI less terrible
746f36e9f2 search_form.html: update filters help
626a3fd683 search_form.html: format
3c5cca9265 search.php: supply flag filter enablement
Compare 26 commits »
Zankaria merged pull request leftypol/leftypol#127 2025-07-08 13:59:53 -05:00
Refactor the search subsystem
Zankaria commented on pull request leftypol/leftypol#134 2025-07-07 17:35:12 -05:00
Fix high CPU usage with overboard's catalog

Issue seems to stem from vichan using A FUCKING REGEX to append the limit to the generated query. Should be solved by using implode to generate the unified query and then append the limit.

Zankaria pushed to rework-search at leftypol/leftypol 2025-07-07 17:33:30 -05:00
26ad13bbea search_form.html: make the search for UI less terrible
746f36e9f2 search_form.html: update filters help
626a3fd683 search_form.html: format
3c5cca9265 search.php: supply flag filter enablement
c9610bb237 search.php: handle query too broad error
Compare 23 commits »