Which server database is faster?

[Rogerio_Rios (Professional Support)]

Maybe this

[Custom]How to load data one by one on user scroll from Airtable, Firebase, Mysql

Hi gyz i present you my another powerful app for custom data loading on user scroll(concept of RecyclerView) from Airtable, Firebase and mysql under jugard series project 6 Note i did not focus on code optimization so that everyone can understand it easily I’ll keep on updating the guide for more convenience and try to make it easily understandable methods and extensions used I used Mysql snippet and php file by @Taifun Dynamic components extension by @yusufcihan Vertical Scroll handler …

[Enderman (Shreyansh)]

As @Taifun said

well, you only asked @Peter, so I do not know, if you are interested in other opinions…
concerning Airtable and Google Spreadsheets there already is a statement here

My opinions :

MySQL is better as you have VPS Hosting Server. You could see some guides in kodular community for help

btw, I still don’t know MySQL

Before I used Airtable mostly. But know I use baserow

I recommend self-hosted baserow DB as you have VPS

~Yours Faithfully
Enderman aka shreyansh

[Lily]

@Enderman

I recommend self-hosted baserow DB as you have VPS

What I just want to know is that, which is the fastest than the other?

1: Baserow
2: MysQL
3: Google Spreadsheet

Between those three above which is the best and fastest to load data?

[Avijit (Avijit Das)]

Every database is fast if you can create a good structure.

[Lily]

sure I currently use airtable with 4 procedures such as

1. videoData
2. dataNews
3. standingData
4. fixituresData

Before I load data to procedures I make sure that all data are loaded from airtable and it only takes 4-6 seconds to load data but getting into a procedure it takes more than 1-2 minutes

That makes the app to crush if the user touches the screen before the procedure finishes to load.

please is there any methods I can use to make it load faster?

[Lily]

@Rogerio_Rios

Maybe this

I am trying to follow

@Zia_Choudhary

Airtable

But I am confused on how to use these blocks!

I can run the data from the cell of the airtable but how do I add each data cell into Dynamic Listview smoothly without crushing or waiting a lot of minutes or seconds!

[Kevinkun]

@Lily

all data are loaded from airtable and it only takes 4-6 seconds to load data but getting into a procedure it takes more than 1-2 minutes

how many data/records needed to be downloaded? you need to download all the records every time you open app? did the records will change or always keep same?

[Lily]

@Kevinkun

records

@Kevinkun

the records will change or always keep same?

the records will change everyday

[Kevinkun]

maybe try to fetch 10-20 records every time and show to users. when swipe down/up, fetch more records

[Rogerio_Rios (Professional Support)]

@Kevinkun

when swipe down/up, fetch more records

I showed , This

[Custom]How to load data one by one on user scroll from Airtable, Firebase, Mysql

Hi gyz i present you my another powerful app for custom data loading on user scroll(concept of RecyclerView) from Airtable, Firebase and mysql under jugard series project 6 Note i did not focus on code optimization so that everyone can understand it easily I’ll keep on updating the guide for more convenience and try to make it easily understandable methods and extensions used I used Mysql snippet and php file by @Taifun Dynamic components extension by @yusufcihan Vertical Scroll handler …

[Lily]

@Kevinkun

maybe try to fetch 10-20 records every time and show to users. when swipe down/up, fetch more records

I am using Dynamic Component list-view I am not well familiar with deleting or clearing data from dynamic list-view and I don’t know how to add them on every scroll

[Lily]

@Rogerio_Rios

I showed , This

I tried to follow but I stuck on how to add when scrolling

@bentejui_espaciodigital

but how do you do it if it’s in the same for? An example of my blocks

[Lily]

@Rogerio_Rios

@Kevinkun

when swipe down/up, fetch more records

I showed , This

Hi gyz i present you my another powerful app for custom data loading on user scroll(concept of RecyclerView) from Airtable, Firebase and mysql under jugard series project 6 Note i did not focus on code optimization so that everyone can understand it easily I’ll keep on updating the guide for more convenience and try to make it easily understandable methods and extensions used I used Mysql snippet and php file by @Taifun Dynamic components extension by @yusufcihan Vertical Scroll handler …

I have tried the method from my end but see what I get

It looks that the select list item cannot accept the argument

Maybe someone can help me on this

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

your airtable source alone enough. i just designed to run or load faster from airtable to the maximum… just test the apk but didnot add any other functions… Loading and clicking the cardview alone have added

Lists_UserScroll.apk (5.4 MB)

(In redmi image loading faster but in my oppo it takes few sec)

[Enderman (Shreyansh)]

MySQL if your good or baserow is recommended

[Lily]

@Still-learning

your airtable source alone enough. i just designed to run or load faster from airtable to the maximum… just test the apk but didnot add any other functions… Loading and clicking the cardview alone have added

Lists_UserScroll.apk (5.4 MB)

(In redmi image loading faster but in my oppo it takes few sec)

Thank you genius this has been a great solution to me. I modified the aia with the one I sent you the app now takes 16 seconds instaead of 6-8 minutes.

I know the part which makes the app to delay untill 16 seconds is the JSON file which loads from my website they are two JSONS 1: standing and 2 fixtures I wish I could have known how to load them in smoothly way too.

But thank you very much @Still-learning you are a great teacher.

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

Do not try to load both the JSON at a time. If the first JSON loads and gives you output then you can set another JSON to read and load so you will have enough time

[dora_paz (Dora)]

@Still-learning

i just designed to run or load faster from airtable to the maximum…

Maybe you could create a guide or provide a test aia in order to help others with the same problem

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

@dora_paz

problem

I have used dictionary method and created dynamic component only for first 20 elements rather than the whole data. As the user scrolls it will build up next 20 elements untill user scoll till the bottom

[Rogerio_Rios (Professional Support)]

@Dora, @Zia_Choudhary created this over a year ago (for various types of storage) 🤷

The examples are there in topic, ready to be used.