Android And Mysql Database Communication

Apps like Spotify and Instagram that their database, how fast users to click on buttons respond? How quickly without having to process the information stored in the database? For

Solution 1:

Let us take an example scenario, when you hit a like button

1. the first thing to do is to store in your local DB that a user has liked a particular artist
2. Based on this, you should call an API off your backend which will record this event. But this has to be asynchronous and you shouldn't run this on the Main thread
3. Before you wait for a response from the API, you can go ahead and update the Android view based on the local like counter (you can use sqllite for this)
4. The backend will run a cronjob to get the total amount of likes and put them into another table column
5. So when a new user comes after the cronjob, he/she will see the updated counter