Project

General

Profile

Actions
Copy link

Feature proposal #9949

closed

Rewrite several queries to be more optimized

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

Added by krileon 24 days ago. Updated 13 days ago.

Status:
Closed
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 22 days 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 22 days ago Actions
Copy link
 #2

  • Status changed from Rejected to Resolved

Updated by krileon 13 days ago Actions
Copy link
 #3

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: PDF Atom