#sqlite [1 / 1]

SQLite Localtime Date Modifier is Slow

Today I found a weird bug in my company’s dashboard app where it took a long time to load data from SQLite database. The number of data is not too many (only around 400k> rows), yet it took several seconds to load. This is really weird, especially considering SQLite is famous for its reading speed. Turn out, this issue is happened because I was using localtime date modifier in my SELECT query.