On 30 Oct 2013, at 6:32pm, Raheel Gupta <raheel...@gmail.com> wrote:
> I wanted to create an INDEX (not unique) of the md5sum column. Would the > index also eat up 20 Bytes or more than that ? At least as much space as the total contents of all the md5sum values. Assuming you did a VACUUM before you created the index. But why are you asking us for a vague rule when you can find an exact figure yourself ? Make a copy of your database, create the index, and compare the file sizes. Then you know. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users