[sqlite] database optimization issues.

Here is an example of some tables which I am having very poor performance querying. I was wondering if someone could give me some suggestions as to how I can optimize this. I am using the adobe Air framework (AS3) to access the database. I make the connection to the file like this:

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 wrote: > Felipe Aramburu wrote: > > stmtGetQuestionsNewSystemType.text = 'SELECT > DISTINCT > > Question.id > > AS id, Question.name AS