On 09-11-2011 20:14, Fabian wrote:
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?
Linux (Linux opensuse 2.6.27.56-0.1-default #1 SMP 2010-12-01 16:57:58
+0100 x86_64 x86_64 x86_64 GNU/Linux)
no, i did not reboot, I created two NEW databases, so rebooting should
not make a big difference because its not cached in both cases.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
