if used A, what different does fts3 with sqlite
------------------ 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 <[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
