Raheel Gupta wrote:
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.
You must copy (or symlink) the lmdb source code into the SQLightning source
directory.
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.
I tested TXN_BULK, still pretty slow. Nearly 2.4 times.
Also the space wastage is pretty high. I set a page size of 64K in this and
the space wastage is very high as the DBNAME.db-journal folder has too many
files.
DBNAME.db is 448MB
DBNAME.db-journal is 161MB.
Which is after inserting 100000 rows of 4K = 400MB.
In SQLITE 3.7.17 I get only 6.69% wastage of space.
I wish BDB worked faster to see my alternatives.
BDB is inherently a very slow codebase. Look at the performance difference
between BDB and SQLite3 here http://symas.com/mdb/microbench/#sec1 - on random
writes BDB KV is only 8% faster than SQLite. If you add the SQL parsing
overhead on top of that, that 8% performance margin is erased. If you use
batched random writes, SQLite is already 2% faster than BDB KV, so BDB SQL can
only be slower than SQLite.
Whatever other differences there may be, there is no performance benefit to
using BDB as a backend for SQLite. In most cases there is a performance loss.
--
-- Howard Chu
CTO, Symas Corp. http://www.symas.com
Director, Highland Sun http://highlandsun.com/hyc/
Chief Architect, OpenLDAP http://www.openldap.org/project/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
