Android Question Many records [ chargeable ] MSMySQL

samperizal

Active Member
Licensed User
Longtime User
Regards.

I have a mysql table with many records (approximately 5000000 ) you can import them into sqlite .
I use [ chargeable ] MSMySQL .

An example is possible .

Thank you.
 

DonManfred

Expert
Licensed User
Longtime User
You should split your job into multiple requests to get x number of records. with all entries at once you may run OOM
Maybe 500 or 1000 items at once or so...
After you got the data you start an sql transaction and fill the 500 items into sqlite db. close transaction.
Get 500 more items...
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…