On Apr 26, 2011, at 11:44 PM, Douglas Eck wrote: > 3.1M records. > > When I create an index for a_id it is very slow to create (many hours).
Hmmm... sounds like many hours too many :) For example, as a comparison point, on a underpowered laptop, indexing a randomly sorted text column over ~26 million rows takes around 300 seconds. The same operation over a pre-sorted column takes around 100 seconds. So one thing that might speed up index creation is pre-sorting the data. EIther way, should take minutes at most, not hours :) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users