Re: [Tracker] Sqlite now default in cvs (mysql backend wont compile yet!)

[Jamie McCracken <jamiemcc blueyonder co uk>]

Eyal Oren wrote:
> On 09/26/06/09/06 02:14 +0100, Jamie McCracken wrote:
> > I have ben spending the last few weeks adding in the sqlite/qdbm 
> > complete with indexer and parser.
> just for my information, which parts are now stored where? do you use 
> sqlite only for the keyword-index and qdbm for the rest of the metadata?  
> or something different?

sqlite stores everything mysql stored before + bzipped file contents

QDBM is only used as a look up table/index (aka hashtable) with word as 
key (word -> docID, serviceType, Score). QDBM does not store any data as 
such (the words that are added are broken up, stemmed and stripped of 
stop words so cannot be used to retrieve any data other than getting a 
list of docs that contain a particular word.

--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/