We are developing an application iOS/ Androidthat downloads large amounts of data from the server.
We use JSONto transfer data between the server and client devices.
Recently, the size of our data has increased significantly (about 30,000 records).
When retrieving this data, the server request expires and data is not received.
Can anyone suggest a better way for fast data transfer?
Is there any method for preparing the data initially and loading the data later?
Is there any advantage of using multiple databases in a device ( SQLitedbS) and parallel insertion in db?
Currently, we only upload / download modified data (using UUIDtimestamps as well).
Is there a better approach to achieve this effectiveness?
---- Edit -----
I think this is not only a mysql record problem, at peak times several devices connect to the server to access data, so connections are also waiting. we use a performance server. I am basically looking for a solution to handle this synchronization on a device. any good way to simplify synchronization or make it faster using multithreading, multiple sqlite db etc ...? or data compression using views or ...?
source
share