What are some tips for achieving maximum insert performance with Cb Lite on Android?
At current, I’m trying to load about 50K documents and can only load about 10-20 documents per second using a Galaxy Tab 4.
I’m also creating my own id. Is is more performant to do that or let cblite create the id and use a view instead?
I’ve tried using transactions, and that works well using the .NET driver. But I"m getting out of memory exception on Android with this many documents.
Is it possible and supported to bulk load directly to the sqlite file maybe?
Update: I tried bulk insert with letting cblite create the id and am getting speeds of 39 docs/second. That seems to be the better route so far.
Update2: I should clarify that not using my own id and wrapping the insert process in a transaction was providing a rate of 39 docs/sec. But it crashed after about 15K documents. Without a transaction I’m getting aobut 23 docs/sec. Perhaps, wrapping batches of documents in a transaction will get a little more peformance.