Project

General

Profile

Actions
Copy link

Feature proposal #9949

open

Rewrite several queries to be more optimized

Feature proposal #9949: Rewrite several queries to be more optimized

Added by krileon 3 days ago. Updated about 18 hours ago.

Status:
Resolved
Priority:
High
Assignee:
krileon
Target version:
4.0.0
Start date:
28 September 2026
Due date:
% Done:

100%

Estimated time:

Description

The All Groups count query is incredibly unoptimized causing long load times on larger sites. Updates of 2s query time. This can be optimized with, already created just needs implemented, an improved query reducing this down to less than 10ms.

Updated by krileon about 18 hours ago Actions
Copy link
 #1

  • Status changed from Assigned to Rejected
  • % Done changed from 0 to 100

Complete query optimization pass across all of GJ and its integrations. On 1 million rows the performance gains are substantial. From 2s down to less than 10ms on several group related queries.

Updated by krileon about 18 hours ago Actions
Copy link
 #2

  • Status changed from Rejected to Resolved
Actions
Copy link

Also available in: PDF Atom