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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
