Project

General

Profile

Actions

Improvements #12117

closed

Allow count query alternative

Added by Matthias Van Ceulebroeck over 1 year ago. Updated 20 days ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
11/06/2023
Due date:
% Done:

100%

Estimated time:

Description

Originally this ticket aimed to improve the query itself. This is however not really feasible, and the database manager will already perform optimizations, such that any other improvements we could perform are essentially meaningless.

As such, this ticket was changed such that:

  • the count query that QueryModel uses to return the row count can be provided an alternative
  • the [Query::createQueryCountSql()] can be provided another query as an alternative

Related issues 1 (1 open0 closed)

Related to Feature #13180: Alternative to WTableView with infinite scrollingInProgressMatthias Van Ceulebroeck11/04/2024

Actions
Actions #1

Updated by Matthias Van Ceulebroeck 5 months ago

  • Target version changed from 4.11.0 to 4.11.1
Actions #2

Updated by Matthias Van Ceulebroeck 5 months ago

  • Target version changed from 4.11.1 to 4.11.3
Actions #3

Updated by Matthias Van Ceulebroeck 4 months ago

  • Subject changed from Improve `createQueryCountSql` to Allow count query alternative
  • Description updated (diff)
Actions #4

Updated by Matthias Van Ceulebroeck 4 months ago

  • Related to Feature #13180: Alternative to WTableView with infinite scrolling added
Actions #5

Updated by Romain Mardulyn 3 months ago

  • Status changed from New to InProgress
  • Assignee set to Romain Mardulyn
Actions #6

Updated by Romain Mardulyn 3 months ago

  • Status changed from InProgress to Review
  • Assignee deleted (Romain Mardulyn)
Actions #7

Updated by Matthias Van Ceulebroeck about 2 months ago

  • Assignee set to Matthias Van Ceulebroeck
Actions #8

Updated by Matthias Van Ceulebroeck 20 days ago

  • Status changed from Review to Implemented @Emweb
  • Assignee changed from Matthias Van Ceulebroeck to Romain Mardulyn
  • % Done changed from 0 to 100
Actions #9

Updated by Matthias Van Ceulebroeck 20 days ago

  • Status changed from Implemented @Emweb to Implemented @Test
Actions #10

Updated by Matthias Van Ceulebroeck 20 days ago

  • Status changed from Implemented @Test to Closed
Actions

Also available in: Atom PDF