Dear Mr. Binns,
To test it simple and easy way, I just made test data and results on my
build server.
<test query: is.sql>
create table test (id integer primary key autoincrement, value text);
insert into test(value) values ("This is test data.");
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
insert into test(value) select value from test;
[test results]
ivy:~/temp$ time ./sqlite3_3763 3763.db < is.sql
real 0m3.996s
user 0m3.510s
sys 0m0.440s
ivy:~/temp$ time ./sqlite3_378 378.db < is.sql
real 0m4.622s
user 0m4.280s
sys 0m0.300s
2011/9/28 Roger Binns <[email protected]>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 09/27/2011 10:18 PM, YONGIL JANG wrote:
> > should I wait for newer version?
>
> You should provide sufficient information (ideally source code and data) so
> that other people can reproduce what you are experiencing.
>
> Roger
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAk6CuxYACgkQmOOfHg372QSymgCeO0Smredq3ZeTzdlN7u/qxIt2
> /AcAoKBT8CoRbSBqRpDZ1l8TE86rzldf
> =KlJI
> -----END PGP SIGNATURE-----
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
