Paul Sanderson <sandersonforens...@gmail.com> wrote: > I have a table with just a few columns, one is a SHA1 hash and the > second an MD5, there are about 17 Million rows in the table > > if I create an index on the SHA1 column using "create index if not > exists sha1index on hashtable(sha1)" the process takes about 3 > minutes, if I follow this immediately by creating a second index on > the md5 column "create index if not exists md5index on hashtable(md5)" > this process takes over 30 minutes. > > Any ideas as to why this might be?
You happened to insert the rows originally in the order of increasing SHA1. So the table is already sorted (or mostly sorted) by SHA1, but not by MD5. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
