On Nov 20, 2009, at 11:48 AM, ouwind wrote: > if used A, what different does fts3 with sqlite
Right, structure A is just a regular SQLite table. It is structure B, the full-text index, that makes fts3 different. > ------------------ > ouwind > 2009-11-20 > > ----------------------------------------------------------------------------------------- > 发件人: Dan Kennedy <[email protected]> > 发送时间: 2009-11-20 12:32 > 主 题: Re: [sqlite] how index stored by fts3 > 收件人: General Discussion of SQLite Database <sqlite- > [email protected]> > > > > On Nov 20, 2009, at 10:24 AM, ouwind wrote: > >> >> it used revert index or just index >> for example: >> i insert some records >> 1:"i am a boy" >> 2:"i am a girl" >> 3:"you are a boy" >> >> what's the table stores like >> option A: id, content >> 1, i am a boy >> 2, i am a girl >> 3, you are a boy >> option B: value, docid >> i , 1,2 >> am , 1,2 >> a , 1,2,3 >> boy , 1,3 >> girl , 2 >> you , 3 >> are , 3 >> >> it used struct A or B? > > Both, as it happens. Structure B is stored in a tricky way > to minimize its size. > > Dan. > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
