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 <yongilj...@gmail.com> 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 <rog...@rogerbinns.com>
>
> > -----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
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
