search

woodruffr1973 / ardb

Automatically exported from code.google.com/p/ardb
0 stars 1 forks source link

Embed Sqlite #9

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Embeding sqlite to Ardb could be great it will effectilvely reduce some
compatibility issues.

Consider a sqlite embeded version upgrade btw. http://www.sqlite.org/
version 3.5.1 Oct 4 2007

meshee: AFIK api of sqlite 3 is slighly different from sqlite 2

Original issue reported on code.google.com by meshee.k...@gmail.com on 5 Nov 2007 at 10:00

GoogleCodeExporter commented 9 years ago 
Speaking of embedding sqlite3:
It should be nice to include fts2 (Full Text Search Two by Google) extention

http://code.google.com/apis/gears/api_database.html#sqlite_fts
http://www.sqlite.org/cvstrac/wiki?p=FtsTwo

 "In a test which loads the Enron email corpus (1.4G of data across 517,431
documents), fts1 required 13.5 hours, while fts2 required 35 minutes. This was 
with
pagesize=4096, synchronous=off, 100 inserts per transaction." 

That could highly enhance search perfs.

Original comment by meshee.k...@gmail.com on 9 Nov 2007 at 10:48

GoogleCodeExporter commented 9 years ago 
I'm going to close this off now.  The current package maintainers seem to have 
this
under control.  I'm not sure I want to replace the DB backend now everyone 
seems to
have it working.

Original comment by graham.r...@gmail.com on 29 Mar 2008 at 10:21