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
