B4J Question Tableview loading 120 000 rows form a 7MB file, ram usage goes to 4GB

[Coldrestart]

Hello everyone,

I have a datafile of 7MB of data, as a csv file.
I load it with the following code into a tableview.
The code works, but even in release mode, my ram memory goes to 4GB, as the file with the data is just 7MB...

What am I doing wrong?
I know for each "cell" a label object is created, is that the reason that it takes so many memory?

TV_RAW_DATA.Items.Clear
       

        Dim row() As Object
       
        For i = 0 To List1.Size-1
                           
            Cols =  Regex.Split(DelimiterInternal(chb_Delimiter.SelectedIndex),List1.Get(i))  
           
            'If we have column names, then add the as column name first.
            If (chkb_ColumnNamesOnFirstLine.Checked = True) And (i = 0) Then
                TV_RAW_DATA.SetColumns(Cols)
                                           
                Else  

                    'Otherwise, just add the data  
                row =  CreateRow(Cols)
                TV_RAW_DATA.Items.Add(row)
               
            End If          
        Next

Sub CreateRow(Row() As String) As Object()
    Dim labels(Row.Length) As Object
    For i = 0 To Row.Length - 1
        Dim lbl As Label
        lbl.Initialize("")
        lbl.Text = Row(i)
        labels(i) = lbl
    Next
    Return labels
End Sub

 

[EnriqueGonzalez]

What am I doing wrong?

Showing all that information at the same time is really an issue. for each cell you are creating a label, for each row you are creating an array of labels so 7mb of data is just a lot of columns and a lot of rows.

TableView was not made to be shown that many information. You want to use B4xTable that will keep in memory most of that data and only show a very small percentage of it to the user.

 

[xulihang]

Since the screen cannot display all the information, you can use lazy load to save memory.

These are for list view. You may need to adapt this for Tableview:

[B4X] PreoptimizedCLV - Lazy loading extension for xCustomListView

This is a cross platform class that extends xCustomListView and makes it "lazier". Lazy loading is explained here: https://www.b4x.com/android/forum/threads/b4x-xui-customlistview-lazy-loading-virtualization.87930/#content and here...

www.b4x.com

ListView scroll changed event for lazyload

This is useful to lazy load a listview, as customlistview costs more memory. This is the reference webpage: https://www.superglobals.net/javafx-listview-lazy-loading/ Sub addScrollChangedEvent Dim jo As JavaObject jo=ListView1 Dim nodes() As Object...

www.b4x.com

 

[Coldrestart]

Thanks for all of your proposed solutions, I will give it a try.

 

[Erel]

Use B4XTable instead.

 

[Coldrestart]

I switched to B4XTable, and have some issues.
First, I want to check the members on the website under "learn" and "guides", but there I don't see any information of the functions.

B4A - B4XTable

www.b4x.com

How can I make the header labels or fields bigger, to show all header data? (like the number of page that is shown)

Thanks in advance.

I started a new thread for this question:

B4XTable change size of header information for big numbers

Hello everyone, In a B4XTable, how can I make the header labels or fields bigger, to show all header data? (like the number of page that is shown) Thanks in advance.

www.b4x.com

 

[Erel]

How can I make the header labels or fields bigger, to show all header data? (like the number of page that is shown)

Better to start a new thread for this.