Yes, you're right, but if the data is already in index order, you'll do less I/O when creating the index. Whether the sort + create DB time is less than "create DB from random input" time is another question.
Jim On 3/29/09, mrobi...@cs.fiu.edu <mrobi...@cs.fiu.edu> wrote: > question: > When you say >> 2) Sort your input file on the PRIMARY KEY >> or on some other INDEX > > I thought that while sqlite inserts the data it is creating the indexes > therefore sorting the data by way of the index, is this corret? > I have decared one column ONLY, unique and indexed. -- Software first. Software lasts! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
