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.