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 outsid
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 SQLite that lacks
some op
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
>
> What is AIR ?
I think, s
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 have
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
___
5 matches
Mail list logo