2011/11/9 Luuk <luu...@gmail.com>
> 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% > > Did you do a reboot between the second insert? Because the difference I'm seeing is much larger than 38%? Did you test it on Linux or Windows? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users