+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for XBMC (/forumdisplay.php?fid=116)
+---- Forum: XBMC Remote for Android Official Forum (/forumdisplay.php?fid=129)
+---- Thread: The Sandbox just opened... (/showthread.php?tid=110143)
Pages: 1 2
- smee204 - 2012-01-07 20:27
smee204 Wrote:I have had a quick look so far and it looks like the slowest part is not receiving the data but inserting it into the local phone database.
On my system it takes 5892ms to sync and 4416ms of that is inserting the data. I am investigating...
Think I have worked out how to speed it up a lot. Will give it a go tomorrow.
- gfoldv - 2012-01-08 00:53
In general the ContentProvider.applyBatch is slow because it does a lot of string comparison operation to turn the URIs to tables. The ContentResolver.bulkInsert is faster although "This function make no guarantees about the atomicity of the insertions".
- freezy - 2012-01-08 01:17
@hunkyn: Direct MySQL access probably isn't such a good idea, because most a) most people probably don't use MySQL anyway and b) as smee204 stated fetching the data is not the bottleneck.
Smee204 I'm looking forward to your result! Cheers!