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