Continious transaction with ContentProvider

Question

I have a huge XML file (more than 20 Mb) and I can't change its format. It represents DB. In fixed periods of time it can change and I must update all changed data on a device.

I am using SyncAdapter to transfer a huge amount of data from XML to SQLite via ContentProvider. I can't use applyBatch(), because I can't keep all the data in the memory, I want to use the following approach:

Start nonExclusiveTransaction
I want to clear all of the tables in DB (Searching for deleted, updated and created records is slow.)
Parse XML using SAX parser and insert rows as soon as they appear
Commit transaction

I can't find a way to begin and commit a transaction outside ContentProvider. Should I look for a different way to save records in ContentProvider from a 20 Mb XML file?

how many records do you have in total and how many of them change? — pskink, May 05 '14 at 20:08
@pskink I have about 150 000 records. I can't predict how many of them will change, may be 1 may be half. — Vladimir Tagakov, May 05 '14 at 20:19
150k of inserts? it will take a week or two... seriously did you try to mske 150k inserts? — pskink, May 05 '14 at 20:32
@pskink Yes I did. My Nexus 7'12 doing about 11.5k simple inserts per second. In one transaction. But I cant understand how I can call beginTransaction() outside ContentProvider =( — Vladimir Tagakov, May 05 '14 at 23:34
to be honest i dont know why you need SyncAdapter and ContenrProvider for updating your db... — pskink, May 06 '14 at 06:58

score 0 · Answer 1 · edited May 23 '17 at 10:33

0

You can get reference to your ContentProvider implementation by calling

acquireContentProviderClient(authority)

Look at this SO answer

After that just cast object that acquireContentProviderClient returns to your custom ContentProvider and call your methods that start and end transactions.

edited May 23 '17 at 10:33

Community

1
1

answered Sep 05 '14 at 14:51

Vladimir Tagakov

107
1
8

Continious transaction with ContentProvider

1 Answers1