[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

Re: [sqlite] Problem with sqlite providing different programs different data

Hey thanks for the advice after further testing I found this to be a windows file system issue. windows made a boo boo and had discrepancy between what could be accessed on the command line and what was shown in windows On Thu, Apr 1, 2010 at 3:11 PM, Tim Romano wrote: >

Re: [sqlite] Problem with sqlite providing different programs differentdata

That's not the issue i am 100 percent certain i am pointing to the file On Apr 1, 2010 1:17 PM, "Igor Tandetnik" <itandet...@mvps.org> wrote: Felipe Aramburu <fel...@kwhours.com> wrote: > So heres the basica scenario: > > 1. i update my data... My guess would be,

[sqlite] Problem with sqlite providing different programs different data

I have some code that is using flex sdk 3.2 and I am updating and inserting into a database with the following queries: stmt.text = 'INSERT INTO Question( hotlist, name, label, datatypeid, advanced, multivalue, measurementtypeid) VALUES (@hotlist,

[sqlite] database optimization issues.

ne could point me in the right direction. thanks, Felipe Aramburu ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database optimization issues.

Thanks I actually resolved this. I wasn't using a UNION operator On Wed, Mar 17, 2010 at 5:50 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Felipe Aramburu wrote: > > stmtGetQuestionsNewSystemType.text = 'SELECT > DISTINCT > > Question.id

[sqlite] Fwd: database optimization issues.

I was hoping someone could point me in the right direction. thanks, Felipe Aramburu ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users