Re: [sqlite] Question About SQLITE and AIR efficiency

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

Re: [sqlite] Question About SQLITE and AIR efficiency

On Sun, Jun 20, 2010 at 6:11 PM, 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. > > This might be because AIR is using an older version of

Re: [sqlite] Question About SQLITE and AIR efficiency

On Sun, Jun 20, 2010 at 5:18 PM, Simon Slavin 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 > >

Re: [sqlite] Question About SQLITE and AIR efficiency

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 am using prepared statements, synchronous connection. Does anyone

[sqlite] Question About SQLITE and AIR efficiency

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. I am using prepared statements, synchronous connection. Does anyone have any idea why a query takes 8 times longer in air? Felipe