Bug 351702 - Kexi table view limited to ~880k records
Summary: Kexi table view limited to ~880k records
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 2.9.5
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-08-24 17:44 UTC by Germano Massullo
Modified: 2021-03-10 16:10 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
For 2M of records, not even half of them visible. (23.24 KB, image/jpeg)
2015-08-24 22:11 UTC, Jarosław Staniek
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Germano Massullo 2015-08-24 17:44:02 UTC
If you try to open a database with Kexi, and a table has millions of entries, if you will put scroll bar at bottom down, you will not see lastest entry, but Kexi will be stuck at a certain entry of the table.
In a few words: Kexi cannot scroll down after a certain data record

Reproducible: Always
Comment 1 Jarosław Staniek 2015-08-24 17:54:46 UTC
Thanks for the report, Germano

What would be the minimum number of records that still demonstrates the issue?
Comment 2 Germano Massullo 2015-08-24 17:56:10 UTC
(In reply to Jarosław Staniek from comment #1)
> Thanks for the report, Germano
> 
> What would be the minimum number of records that still demonstrates the
> issue?

Did you mean: "after how many records do you experience the bug"?
Comment 3 Jarosław Staniek 2015-08-24 18:51:28 UTC
Yes, (at least): how many.
Comment 4 Germano Massullo 2015-08-24 19:04:17 UTC
Lastest record I can partially see is number 932068
Comment 5 Jarosław Staniek 2015-08-24 19:11:09 UTC
Thanks! Will be tested with 1M of records.

By the way, out of curiosity, what db driver is that?
Comment 6 Germano Massullo 2015-08-24 19:14:03 UTC
(In reply to Jarosław Staniek from comment #5)
> Thanks! Will be tested with 1M of records.
> 
> By the way, out of curiosity, what db driver is that?

The original file is a MDB file.
Comment 7 Jarosław Staniek 2015-08-24 19:28:22 UTC
Ah, so imported. Good.
Comment 8 Jarosław Staniek 2015-08-24 22:10:49 UTC
Thanks, confirmed on a 2M of records.
Comment 9 Jarosław Staniek 2015-08-24 22:11:54 UTC
Created attachment 94209 [details]
For 2M of records, not even half of them visible.
Comment 10 Jarosław Staniek 2015-08-24 22:18:19 UTC
For me ends at row 883011 no matter if there are 1M or 2M rows to show....
Comment 11 Jarosław Staniek 2015-08-24 23:00:12 UTC
Found it:

QWIDGETSIZE_MAX/row_height == 16777215/19 == 883011

I will have to employ some math to overcome the limit.
Comment 12 Jarosław Staniek 2015-08-26 21:55:57 UTC
Example with 1M of records (1.3MB): http://kexi-project.org/download/tests/351702-1M.kexi.xz
Comment 13 Jarosław Staniek 2016-01-21 22:30:53 UTC
Fixing it takes more time than expected. Looking for solutions.
Comment 14 Justin Zobel 2021-03-09 23:43:30 UTC
Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.
Comment 15 Germano Massullo 2021-03-10 16:10:21 UTC
I am no longer able to import a MDB file so I cannot verify the status of the bug