Re: [sqlite] indexing for integer column

Hi, Can I create INDEX for the particular column when database journal mode is WAL? Any impact If I INDEXed database with some triggers? Thanks in advance. Best Regards, On Thu, Sep 6, 2012 at 4:04 PM, Durga D wrote: > Thank you Kees. > > > On Thu, Sep 6, 2012

Re: [sqlite] indexing for integer column

Thank you Kees. On Thu, Sep 6, 2012 at 3:34 PM, Kees Nuyt wrote: > On Thu, 6 Sep 2012 12:02:03 +0400, Durga D wrote: > > >Hi All, > > > >Somehow "original author" missed one INTETER column as searchable > >field ( like unique or primary key) in the

Re: [sqlite] indexing for integer column

On Thu, 6 Sep 2012 12:02:03 +0400, Durga D wrote: >Hi All, > >Somehow "original author" missed one INTETER column as searchable >field ( like unique or primary key) in the table. When execute queries >based on this integer field in where clause/joins, huge performance

[sqlite] indexing for integer column

Hi All, Somehow "original author" missed one INTETER column as searchable field ( like unique or primary key) in the table. When execute queries based on this integer field in where clause/joins, huge performance hit. So, I am planning to add INDEXING for this integer column. Is there