Skip navigation
guy88
Currently Being Moderated

Performance Issue with SQLite

Mar 11, 2013 8:21 PM

Hi

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 flash.data.SQLConnection and flash.data.SQLStatement 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.

 
Replies

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