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
