Hi have to make an app that gets a big XML with 10000+ records.
I have to place them in a sqlite database with the following checks:
- if record not exist insert record
- if record exist but upload =0 (in sqlite db on tablet) then update record
- if record exist but upload =1 (in sqlite db on tablet) then ignore record
What is the best/fastest way to insert/update this many records?
use the xmlparser and insert/update record for record or is there a better way to do it?
regards, Eddy
I have to place them in a sqlite database with the following checks:
- if record not exist insert record
- if record exist but upload =0 (in sqlite db on tablet) then update record
- if record exist but upload =1 (in sqlite db on tablet) then ignore record
What is the best/fastest way to insert/update this many records?
use the xmlparser and insert/update record for record or is there a better way to do it?
regards, Eddy