Browsing All Posts filed under »SQLLite«

Android SQLite Tip 2 – Use compiled SQL statements

August 16, 2011

4

In my last article  I talked about SQL Lite inserts on Android being optimised using a transaction. Another method I’ve found that speeds things up dramatically is to use compiled SQL statements with the SQLiteStatement class. I can’t believe I hadn’t used these before, I actually think working with a compiled statement is much nicer than working with the  standard SQL […]

Android SQLite tip 1 – Wrap batches of writes in a transaction

August 16, 2011

4

I’ve been working on the Shhmooze Android app. When the app is first run there are quite large amounts of data that need to be downloaded and persisted to an Android SQLLite db on the device(around 200o records). I was running into an issue where these writes to the db were taking a very long […]