limit of the table component

[flosigime]

It seems that the table component has a limit of lines it can shows. It seems to be 20 000.
Is there a way to show more lines ?

[lovasoa]

Hi ! Long time no see ! How have you been doing ? The table component is not supposed to have such a limitation !

Here is a very simple sql file you can use to create a table with 20001 rows:

with recursive n(x) as (
    select 1
    union all
    select x + 1
    from n
    where x < 20001
)
select x from n;

Since SQLPage functions in a streaming fashion, you can even create an infinite table by removing the where clause from the query above. This will create a page that never stops loading (until your tab does not have enough memory and crashes).

That said, creating huge tables is probably not the best experience for users. It's generally recommended to facet your data, or make it filterable and sortable to create pages that are smaller, faster, and easier to navigate around.

[flosigime]

Hi!
we did'nt really expected this use in fact. It's the first huge collect and it works good, despite this behaviour...

top of the table, sort descending

top of the table, sort ascending

bottom of the table, sort ascending

[flosigime]

still an old version : 0.25 !!! oups....

[lovasoa]

I can't do much with these screenshots, unfortunately; if you want me to look into it you'll need to make a minimal reproduction that doesn't depend on your app !

[flosigime]

The idea was just to show you what happens.
On the first capture, you see that the biggest number is 24808. The second capture shows that the smallest number is 10001, and on the third, that, when we sort table ascending, the last number showed by the table is 20000. So, in fact, "only" 10000 numbers are visible in the full table when it is sorted.
Of course, the best thing to do is to split table in pages for exemple and to use filters and search field.