Which server database is faster?

[Lily]

@Peter

Just found this on the Baserow Community

Hello @Peter please from your experience which Database is more faster than the other for example I have been using airtable and Firebase for years now and I can comfirm that Airtable is not relaible at all because it is too slow and has limits for row fetching, but also firebase is costfull.

So, I would kindly like to ask which is fater than the other comparing baserow vs google spreadsheet I have never used any of it but I want now to give a try on one of it which is faster to call data and show them on dynamic componet

Also I have VPS Hosting Server but for sure I don’t know how to use mysql also I am not sure if it will be faster to get data and show on the app because a lot of users complain against my apps that they are too much slow in onpening and running and then I understand that it is because I use airtable to get data without their notes!

So please I am searching for a best solution.

[Taifun]

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

Using Google Spreadsheets - Far better than Airtable Database

The way is more fast, convenient and free in comparison with airtable. Thank you so much

but what about first describing your requirements?
how many tables do you plan to use?
how many rows do you expect to have for each table?

generally from a relational database point of view… in terms of speed I would suggest to use a professional database, which is MySQL, which additionally offers a lot of tuning possibilities, see for example MySQL :: MySQL Performance Tuning and Optimization Resources

as a start you can try my MySQL solution here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps

EDIT: some other opinions you can find in this thread

Firebase vs Airtable

Which of these sites would you use to make an app?

Taifun

[Lily]

@Taifun

Taifun

@Taifun

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

@Taifun

but what about first describing your requirements?
how many tables do you plan to use?
how many rows do you expect to have for each table?

generally from a relational database point of view… in terms of speed I would suggest to use a professional database, which is MySQL, which additionally offers a lot of tuning possibilities, see for example MySQL :: MySQL Performance Tuning and Optimization Resources

I real appreciate your suggestions I have never used MySQL but I would like to give it a try thank @Taifun
But the other problem is when I use Dynamic listview it takes a long time to load the data on the screen, so someone help how to solve this at least to make the data load only for 5 seconds or 10 seconds.

[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