On Sun, Jun 20, 2010 at 5:18 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 20 Jun 2010, at 11:11pm, Felipe Aramburu 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 > > What is AIR ?
I think, some Adobe run-time environment. You would be better off asking on an Adobe-specific list, or, provide way more information than you did, and hope to get lucky with someone else on this list who uses AIR. > >> I am using prepared statements, synchronous connection. Does anyone have any >> idea why a query takes 8 times longer in air? > > How long does the query take if you execute it in the sqlite3 command-line > tool ? You can use '.timer ON': > > http://www.sqlite.org/sqlite.html > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users