Re: [sqlite] SQLite 3.7.8 version - insert query speed decreased

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

Re: [sqlite] SQLite 3.7.8 version - insert query speed decreased

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 wrote: > Dear Mr. Binns, > To test it simple and easy way, I just made test data and results on my > build server. > > > create table

Re: [sqlite] SQLite 3.7.8 version - insert query speed decreased

Dear Mr. Binns, To test it simple and easy way, I just made test data and results on my build server. 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

Re: [sqlite] SQLite 3.7.8 version - insert query speed decreased

-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-

[sqlite] SQLite 3.7.8 version - insert query speed decreased

Dear all, I'm using sqlite 3.7.6.3 version on my system. And, I'd tried to use 3.7.8 version, because of retrieval query speed of distinct and group by has been increased. Really, it shows improved performance for several scenes in my application. However, insert queries of 1,000 entries to