On Fri, Aug 12, 2011 at 12:28 AM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Aug 11, 2011 at 2:48 PM, Abhinav Upadhyay < > er.abhinav.upadh...@gmail.com> wrote: > >> On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson >> <domehead...@gmail.com> wrote: >> > If you use INTEGER PRIMARY KEY, that column becomes your rowids; this >> does >> > not create a new, separate column in addition to the rowid column. >> Indeed, but the INTEGER PRIMARY KEY column would count as a user >> defined column and thus affect the FTS search :) The FTS table has all >> text data, so I really do need to create a separate column for the >> IDs. >> > > Every FTS table has a "docid" column that is not searched, that is a unique > integer key (like rowid), and which is not modified by VACUUM. Ah, that saves the day for me :-) . Using VACUUM brings down the size of my databse by 1/3rd, so I really wanted to use it.
Thanks :) Abhinav _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users