iOS Question Problems with database view

[toro1950]

I have two identical Apps, one Android and one iOS, which have a customer database. The database is made up of only 4 fields, on the Android version I have no problems, I tested it up to 7000 records even if it will reach a maximum of 5000 records. on the iOS version the app can correctly display a database with a maximum of 2400 records, if the records are higher the app shows them regularly for a few moments then exits. this is my code that matches both systems

private Sub updateclienti
    listacl.Clear
    n=0
    Dim Query As String
    Dim ResultSet1 As ResultSet
    SQL1.Initialize(SQLDataBasePath, nomedbcl, True)
    Query = "SELECT * FROM clienti"
    ResultSet1 = SQL1.ExecQuery("select * from clienti")

    Do While ResultSet1.NextRow
        n=n+1
        Dim p As B4XView = xui.CreatePanel("")
        p.SetLayoutAnimated(0, 0, 0, listacl.AsView.Width, 30dip)
                
        p.LoadLayout("itemcl")
                        
        label1.Text= ResultSet1.GetString("nome")
        label2.Text =  ResultSet1.GetString("danapet")
        label3.Text= ResultSet1.GetString("cell")
        label4.Text= ResultSet1.GetString("idcl")
        listacl.Add(p, Null)
    Loop
    label16.Text= n
    ResultSet1.Close

End Sub

what could it be? has anyone had the same problems? What do you advise me to do to identify the error that seems strange to me, from 0 to 2400 records there are no problems

 

[aeric]

Is there any error message when the problem occurs?

 

[toro1950]

No! no errors are displayed

 

[aeric]

For a long list of items, it is recommended to use lazy loading or preoptimized CLV.

[B4X] [XUI] CustomListView - lazy loading / virtualization

xCustomListView v1.50 adds an important new event named VisibleRangeChanged. This event is fired whenever the visible range of items changes. We can use this event to defer the items creation. This can significantly improve the performance of lists with complex items. As an example, if we try...

www.b4x.com

[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