On 1 Mar 2017, at 9:41pm, Deon Brewis <de...@outlook.com> wrote: > Yeah ok, but that is paltry compared with the gb's of diskspace that the > actual second index takes up. But thanks for clarifying.
Ah. If it’s really GBs of disk space then I can see why you’d look for alternative solutions. But I have a 43 GB database file which could be 20 GB without an extra index. I could have written that extra check in code, and reduced the file size, but I decided not to. Because once I had developed procedures to handle a 20 GB file, I might was well be dealing with a 43 GB file anyway. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users