> > 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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
