On 25-06-2011 15:15, Black, Michael (IS) wrote: > OK...I generated 10M ints and imported them. I get times that I would expect. > > select with all 3 is slightly less then the sum of the other 3 individually. > > > > main() > { > int i; > for(i=0;i<10000000;i++) { > int j=rand(); > printf("%d\n",j); > } > } > > > > sqlite3 test.db > SQLite version 3.7.5 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > > sqlite> create table test(i int); > sqlite> .import x.csv test > sqlite> .timer on
i created a slightly other table: create table test(i int primary key); and i did not use random numbers but just sequential numbers ;) thanks for sharing your thoughts, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users