S samperizal Active Member Licensed User Longtime User Oct 25, 2015 #1 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.
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 Oct 25, 2015 #2 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
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...
