Project

General

Profile

Actions

Feature proposal #5280

closed

Admin: Improve SQL query efficiency on table filtering

Added by beat over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
18 May 2015
Due date:
% Done:

100%

Estimated time:

Description

In admin area, we join multiple several times same table when searching. This could be a single join per table to optimize the search.


Related issues 1 (0 open1 closed)

Related to CB - Bug #5383: Ahawow: Tablebrowser Filters on joined tables result in SQL error with double-referenced tablesClosedbeat13 July 2015

Actions
Actions #1

Updated by beat over 9 years ago

  • % Done changed from 0 to 90

Implemented most of it in commit 92b29c748b78f33e2357398d6848b02ea00cfca7
Group search still joins groups-map table a second time, so leaving this open until that is fixed too.

Actions #2

Updated by beat over 9 years ago

  • Status changed from New to Assigned
Actions #3

Updated by beat over 9 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 90 to 100

Implemented in MR !890 . Leaving out user groups filtering for a future rewrite.

Actions #4

Updated by beat over 9 years ago

  • Status changed from Resolved to Closed
Actions #5

Updated by beat over 9 years ago

Small regression reported and fixed in #5383

Actions

Also available in: Atom PDF