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? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
