Project

General

Profile

Actions

Feature #13180

open

Alternative to WTableView with infinite scrolling

Added by Matthias Van Ceulebroeck about 2 months ago.

Status:
New
Priority:
Normal
Target version:
Start date:
11/04/2024
Due date:
% Done:

0%

Estimated time:

Description

There are currently two ways to show tabular data in Wt. The first being a WTable, which is fairly customizable, but doesn't take any WAbstractItemModels.
There is also WTableView which can make use of an item model.

If developers wish to show data they have in a database, they can make use of the QueryModel. This will execute a count query on the query, and then calculate the height of the scroll bar. Each batch of items can then be loaded on demand, so that the table itself is more performant, instead of eagerly loading all data. While this is an improvement upon loading all data initially, this still restricts developers in the way that it requires a count query. Now, count queries are fairly costly, as their cost grows proportional to the table's size. In very large tables, a count query can be very detrimental.

A new view on a QueryModel ought to be offered, WInfiniteTableView (name very much subject to change) will avoid this count query, and append results to the view upon scrolling.

Ideally this will also make use of a table element, and not custom divs (like WTableView) so that custom styling is easier to apply.


Related issues 1 (1 open0 closed)

Related to Improvements #12117: Allow count query alternativeReview11/06/2023

Actions
Actions #1

Updated by Matthias Van Ceulebroeck about 2 months ago

Actions

Also available in: Atom PDF