On 09-11-2011 17:23, Black, Michael (IS) wrote:
time sqlite3<index1.sql
19.307u 0.082s 0:19.40 99.8% 0+0k 0+0io 0pf+0w
time sqlite3< index2.sql
19.266u 0.092s 0:19.37 99.8% 0+0k 0+0io 0pf+0w
$ time sqlite3 <gendat1.sql
real 0m21.094s
user 0m20.989s
sys 0m0.104s
$ time sqlite3 <gendat2.sql
real 0m20.898s
user 0m20.813s
sys 0m0.084s
$ time sqlite3 gendat1.sqlite <gendat1.sql
real 2m32.701s
user 0m26.038s
sys 0m5.256s
$ time sqlite3 gendat2.sqlite <gendat2.sql
real 1m50.452s
user 0m25.534s
sys 0m5.360s
The difference when creating a db on disk (size: 35Mb) is (152-110)/110= 38%
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users