Does you query involve LIKE? That has been overriden in AIR so it won't make use of an index. If your queries permit, use GLOB instead.
I have used SQLite with Adobe AIR without any performance problems/slowness other than the one above relating to LIKE. N.B. If your database was designed outside of AIR, be aware that Adobe and SQLite differ with respect to primary keys. In SQLite, a PK defined as INT (as distinct from INTEGER) is a normal column whereas one defined as INTEGER (verbatim, i.e. upper-case I, uppercase N, uppercase T, uppercase E, etc) is treated as an alias for the ROWID; whereas in AIR, INT and INTEGER are treated the *same* -- as aliases for the ROWID. This can wreak havoc if you have any tables with INT primary keys as the wrong rows may be incorporated into the result-set by joins. I discovered this and brought this to Adobe's attention months ago and their decision was to document it rather than to change their implementation. Regards Tim Romano Swarthmore PA On Sun, Jun 20, 2010 at 7:44 PM, Richard Hipp <d...@sqlite.org> wrote: > On Sun, Jun 20, 2010 at 6:11 PM, Felipe Aramburu <fel...@kwhours.com> > wrote: > > > I have a query that I can execute in about 150ms in a sqlite tool like > > sqlite expert professional that takes 1200ms when I execute the query > from > > AIR. > > > > > This might be because AIR is using an older version of SQLite that lacks > some optimization that makes your query run faster. The following > information would be useful in diagnosing the problem: > > (1) "SELECT sqlite_version()" run on both AIR and "SQLite Expert > Professional" > (2) Your schema > (3) The query you are running. > > > > > > I am using prepared statements, synchronous connection. Does anyone have > > any > > idea why a query takes 8 times longer in air? > > > > Felipe > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > --------------------- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
