1

I'm creating Android application that contains a large amount of data. It takes lot of time to access the data. What are optimization technique that I can use ? Are there any optimized queries?

Jeremy Logan
  • 47,151
  • 38
  • 123
  • 143
Rakesh
  • 14,997
  • 13
  • 42
  • 62

4 Answers4

1

This page will give you a lot of good tips on how to optimize SQLite things:

http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html

Keep in mind that some stuff SQLite will optimize for you as well when it runs a query:

http://www.sqlite.org/optoverview.html

dreadwail
  • 15,098
  • 21
  • 65
  • 96
  • Please don't add links as answers, rather put a bit of key info from the page and reference. Often these links change... – tread Jul 22 '15 at 14:38
0

Use parameterized queries to reduce the amount of queries that needs to be parsed, see: How do I get around the "'" problem in sqlite and c#?

Community
  • 1
  • 1
tuinstoel
  • 7,248
  • 27
  • 27
  • i cannot use parameterized queries in sqlite for android database,is there anyother options for Query optimisarion – Rakesh Jul 16 '09 at 06:03
  • Are you sure? I don't know Android. I assumed there is only one kind of Sqlite. – Theo Jul 16 '09 at 07:12
-1

You can use parametrized statements in Android:

http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#compileStatement%28java.lang.String%29

plugmind
  • 7,926
  • 4
  • 34
  • 39
-2

SQLite does not support dates natively (SQLite uses strings to store dates). If you are using an index to access dates - you'll get slow query times (not to mention inaccurate or wrong results..)

If you really need to sort through dates then I'd suggest you create separate columns for the various date elements that you want to index (like years, months, and days). Define these columns as integers and add INDEX statements to index their contents.

Andrew Barber
  • 39,603
  • 20
  • 94
  • 123
Liron Levi
  • 1,139
  • 6
  • 10