Hi, >> You use BDB SQL or BDB KV ? I built BDB 6.0.20 with --enable-sql_compat It made a libsqlite3.so in the .libs folder which I linked with my QT C++ Application.
>> You must try it with SQLightning too, https://gitorious.org/mdb/ sqlightning I tried to build it, but it says lmdb.h missing. Will check it as well. On Fri, Nov 8, 2013 at 4:12 PM, Aris Setyawan <aris.s...@gmail.com> wrote: > This is the BDB SQL doc I found. > > > http://docs.oracle.com/cd/E17076_02/html/bdb-sql/dbfeatures.html#bulkloading > > If you insert record in bulk, you can use PRAGMA TXN_BULK for optimization. > > > > On 11/8/13, Aris Setyawan <aris.s...@gmail.com> wrote: > > You use BDB SQL or BDB KV ? > > > > You must try it with SQLightning too, > https://gitorious.org/mdb/sqlightning > > > > > > On 11/8/13, Aris Setyawan <aris.s...@gmail.com> wrote: > >>> For a single threaded application BDB is very bad after I tested. > >>> It takes nearly 2.5 times the amount of time and CPU to do a > transaction > >>> of > >>> 40MB Data. E.g. If SQLIte did the 40MB data transaction (10000 rows of > 4 > >>> K) > >>> in 1 second, BDB was taking 2.5 seconds and more CPU as well. I did > this > >>> in > >>> QT C++. Overall BDB SQL interface is slower than Sqlite for inserts. > >>> That > >>> is what I found. > >> > >> Have you consult this to the BDB forum? > >> BDB doesn't have SQL parsing overhead, so it will be faster in general. > >> > >> On 11/8/13, Raheel Gupta <raheel...@gmail.com> wrote: > >>>>> If you have many core of processors [and big RAM], then I recommend > >>> BDB Sql over Sqlite. Because you can have many processes or threads to > >>> write to a database concurrently. > >>> > >>> For a single threaded application BDB is very bad after I tested. > >>> It takes nearly 2.5 times the amount of time and CPU to do a > transaction > >>> of > >>> 40MB Data. E.g. If SQLIte did the 40MB data transaction (10000 rows of > 4 > >>> K) > >>> in 1 second, BDB was taking 2.5 seconds and more CPU as well. I did > this > >>> in > >>> QT C++. Overall BDB SQL interface is slower than Sqlite for inserts. > >>> That > >>> is what I found. > >>> > >>> > >>> > >>> On Fri, Nov 8, 2013 at 12:03 AM, Simon Slavin <slav...@bigfraud.org> > >>> wrote: > >>> > >>>> > >>>> On 7 Nov 2013, at 6:31pm, Raheel Gupta <raheel...@gmail.com> wrote: > >>>> > >>>> > Any idea when will SQLite4 be released as stable ? > >>>> > >>>> No. It's not even feature-frozen yet, as far as we know. And > whenever > >>>> it > >>>> is, it's incredibly unlikely to have row level locking. > >>>> > >>>> Simon. > >>>> _______________________________________________ > >>>> 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 > >>> > >> > > > _______________________________________________ > 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