Hi, Igor Tandetnik schrieb: > "Lukas Haase" <lukasha...@gmx.at> wrote in > message news:gv9fcm$5r...@ger.gmane.org >> I have a database containing thousands of HTML pages ("topics"). There >> is a fulltext index for these topics. First there is a table >> containing all single words. Each word is identified by its >> "fulltextID": > > You seem to be reinventing FTS: > > http://www.sqlite.org/cvstrac/wiki?p=FtsUsage
Thank you, but unfortunately not. First, there are 20000 topics, second, these topics are HTML code fragments and third, they are all compressed externally with gzip for saving memory. For that reason I built this index, listing all words for a specific topic... Luke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
