{"id":9,"date":"2019-02-05T19:54:00","date_gmt":"2019-02-05T19:54:00","guid":{"rendered":""},"modified":"2023-11-17T16:40:03","modified_gmt":"2023-11-17T16:40:03","slug":"android-performance-story","status":"publish","type":"post","link":"https:\/\/ahm.basfinans.com\/index.php\/2019\/02\/05\/android-performance-story\/","title":{"rendered":"Android Performance Story"},"content":{"rendered":"

I am developing a personal finance application and it uses SQLite to store all of its data. I had slowness in the application where I calculate balance for all accounts.<\/p>\n

The first thing that came to my mind is that the DB access is slow and I have to research if I should add indexes to the tables. Before doing that, I gave Android Studio Profiler a try.<\/p>\n

\n<\/a><\/div>\n
\nAndroid Studio Profiler<\/a><\/div>\n

What was a surprise to me is finding the slowness is not related to database access but to date conversion function. See:<\/p>\n

<\/p>\n

\n<\/a><\/div>\n

\nSee this code snippet,<\/p>\n

Class DateUtils {<\/p>\n

const val YYYY_MM_DD_HH_MM_SS_S = “yyyy-MM-dd HH:mm:ss”
\nprivate val formatter = SimpleDateFormat(YYYY_MM_DD_HH_MM_SS_S, Locale(“en”))<\/p>\n

fun toDate(dateString: String) : Date  = formatter.parse(dateString)
\n…<\/p>\n

}<\/p>\n

\n<\/div>\n
\nAlthough the formatter object is created once and reused by the toDate() function, the toDate() is extremely slow. Although it is being called for each fetched row from SQLite, I did not expect it to be the performance bottleneck. I always assume DB access is the slowest part of any application which, in my little story, is wrong. <\/div>\n
\n<\/div>\n
\nSo I learned, do not assume, get data and then decide.<\/div>\n
\n<\/div>\n
\n<\/div>\n
From ahm507.blogspot.com<\/div>\n","protected":false},"excerpt":{"rendered":"

I am developing a personal finance application and it uses SQLite to store all of its data. I had slowness in the application where I calculate balance for all accounts. The first thing that came to my mind is that the DB access is slow and I have to research if I should add indexes to the […]<\/p>\n","protected":false},"author":1,"featured_media":245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/posts\/9"}],"collection":[{"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":1,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"predecessor-version":[{"id":247,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/posts\/9\/revisions\/247"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/media\/245"}],"wp:attachment":[{"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ahm.basfinans.com\/index.php\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}