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 <durga.d...@gmail.com> wrote: > Thank you Kees. > > > On Thu, Sep 6, 2012 at 3:34 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > >> On Thu, 6 Sep 2012 12:02:03 +0400, Durga D <durga.d...@gmail.com> 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 hit. >> >So, I am planning to add INDEXING for this integer column. >> > >> > Is there any alternative/best solution? >> >> Make it a UNIQUE INDEX if possible. >> >> Yet, the best thing to do is to refactor the schema. >> >> sqlite3 olddbfile .dump >dumpfile >> edit dumpfile to adjust schema >> sqlite3 newdbfile <dumpfile >> rename olddbfile to olddbfile.ORIGINAL >> rename newdbfile to olddbfile >> start the application, test thoroughly >> >> Inform the original author, so a new release is correct from the >> beginning. >> >> >> -- >> Regards, >> >> Kees Nuyt >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
