Skip navigation
Currently Being Moderated

Performance Issue with SQLite

Mar 11, 2013 8:21 PM


I have an AIR application which interacts with SQLite.

one of my operations runs a fairly complex query in order to fetch (Select) some data.

the amount of data that is fetched is not big at all (around 10 records)

my issue is that the operation takes very long time to finish (1.5 min) when it runs via the application by using the and classes however when running it by itself via an admin tool (I’m using SQLite Expert) it is executed in less than 5sec

Does anyone out there experience the same issue?

any suggestion/solution would be much appreciated here.


More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points