Dear all, I'm so sorry! All of previous test result was my fault!
To get correct information, I'd downloaded all source code again and tested with same configuration. (Of course, fdatasync is enabled by using -Dfdatasync=fdatasync) It shows almost same execution time for each version. I think I'd made some wrong code changes. (But, cannot find the reason until now. T.T) Thanks a lot for your help. And, too sorry. 2011/9/28 Richard Hipp <[email protected]> > Recompile with -Dfdatasync=fdatasync and rerun your test. Let us know the > results, please. > > On Wed, Sep 28, 2011 at 4:31 AM, Felix.Jang <[email protected]> wrote: > > > 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 > > > > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > 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
