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