How can i load big data(12600rows) from csv file using kodular dynamic without lag or freeze

[Ammaraldewani]

if i want to add phase animation in this dynamic , add any phase or phase ?
id , component ?

It’s a lot different from the basic look I’m used to

edit : thanks , fixed

[Still-learning (1-2-3-4...)]

Not every second, every microsecond…

We can increase it, since you want two times in different view I did like this… if I have free time, let me implement. Until pls use or someone may come up with best.

If you give more pressure I hope either app will lack or it will throw getclass() error… anyway still I will look for the best

[Ammaraldewani]

Hi, Sorry for so many questions,
I noticed that when I put more than 2000 rows in size of baserow component the application stop responding when the user presses anything in screen (thats happen only when netwwork connected)
So i add 1500rows instead of 2000rows in size of baserow component
The problem solved by partially!
So if user touch the screen more than 2 touch when data got row by > app not responding

This only when network connected, but when there is no Internet, the application downloads all the data successfully and without any problems
Notice : iam using more than one component of baserow (for example : 2000 - 2000 - 2000 to 12000)

[Still-learning (1-2-3-4...)]

i feel you need to change your methodology cause of more rows… But more rows your are showing in app mean, how user will feel ? Will it be more comfortable? While creating dynamic component more itms in micro seconds do not add any more pressure, i hope you are willing to show phase effect

[Ammaraldewani]

In fact, the user’s first step is to click on the search button,
I’ll try to put a linear progress to prevent user click on screen

[Still-learning (1-2-3-4...)]

Just now tested the app again by adding more number in baserow (2k) but i got only 556 and i feel no issue, it works fine as it is earlier… May be you may have changed anything or disturbs the logic

[Boban (Boban Stojmenovic)]

You might want to try out the new Recycler List Viewer, it loads 12000 rows data in a fraction of a sec

[F/OS] Recycler List View - Render larger data sets efficiently using `RecyclerView` for AppInventor & Distros

[banner] [icon] Recycler List View An extension for rendering larger data sets efficiently using RecyclerView for AppInventor & Distros. Documentation Events [on_create_view] Event raised to create UI. Don’t bind any data to the UI here. Parameters root : AndroidViewComponent [on_bind_view] Event raised to bind data to UI. Parameters root : AndroidViewComponent position: Current position. Functions [initialize] Initiali…

LoadBigDataWithNewRecyclerListView.aia (225.5 KB)

[Ammaraldewani]

thanks

[Ammaraldewani]

I found a small problem when searching
only when searching by (company) it displays infinite duplicate results with (same name same company same at all).!

While other searches like search by name or se all or search by Tarkeb(mean by structure) are normal without problems, there is no error in the blocks.
(image when searching by company(الشركة)

(image when searching by name or Tarkeb or anything else)

[Ammaraldewani]

SCOPEFULL.aia (1.3 MB)
problem in screen (ALLDRUG) that open after screen1 initialize (by start value = NET)

blocks look normall!

[Ammaraldewani]

If it is difficult to solve, no problem, I can put companies manually in another screen and get by value
But the strange thing is that the search feature works well with name, Tarkeb…

[Still-learning (1-2-3-4...)]

I cannot focus on it now. I am in work. After 6hrs only I can see to that.

[Ammaraldewani]

I noticed that it only happens on some results and not all, I don’t know exactly what happens, I think it’s an information overlap

[Still-learning (1-2-3-4...)]

@Ammaraldewani

SCOPEFULL.aia (1.3 MB)

Why are you make app to run too many baserow components? Why dont you run with same baserow?

Certainly your app will lagg or will give you false data or multiples of data du to unique blocks in all the events…

First design logic, then deisgn codes. I believe single baerow is enough to run the task.

You are confusing your app a lot, i think… Imagine this global name list length will bear the number which baserow gor all fields at last, so you will be fail to proceed further

[Ammaraldewani]

@Still-learning

You are confusing your app a lot, i think… Imagine this global name list length will bear the number which baserow gor all fields at last, so you will be fail to proceed further

but the max size of baserow csv file is 4000rows i cant add more than 4000 in baserow

[Still-learning (1-2-3-4...)]

then what should add is, once first baserow got all rows then allow another baserow to run, likewise go on… Once the final baserow got all rows, then finish the work.

@Ammaraldewani

i cant add more than 4000 in baserow

Then why dont you use gsheet as alternate?

[Ammaraldewani]

Can you explain to me what I should do with the blocks but this step maybe cause more seconds to load data ? . The reason for not using Google sheets is that it does not support the Arabic language in some cases. Also, most websites are banned in Syria: airtable, heroku …etc

[image]

[Ammaraldewani]

[Still-learning (1-2-3-4...)]

also you are using same baserow…

it must be different. What will happne is, you will get duplicate items

[Still-learning (1-2-3-4...)]

Finally, I hope the op has achieved his logic through the wonderful Recycler extension , full credit to @zainulhassan extension developer.

Also multiple way of searching also did, that too not takes too much time…

First run only needs data , afterwards I does not need data, based on @Boban method. Earlier searching by single textbox takes too much time with lagging but now filtering data by three text boxes without lagging. Even in every text box at least single text would be enough to sort out data’s from tinydb… for searching does not used any extension instead used a loop.

If anypeople interested just test the APK. And in the three text boxes what need to be searched also shown in the image

As @dora said, single global variable was used to store the items from web / tinydb

SecondRecycler.apk (5.4 MB)