I have worked with numeric data and also "keyword" data, i.e. a small number of distinct keywords that appear in a string (or not).
-----Urspr?ngliche Nachricht----- Von: Dominique Devienne [mailto:ddevienne at gmail.com] Gesendet: Mittwoch, 04. M?rz 2015 10:39 An: General Discussion of SQLite Database Betreff: [sqlite] FastBit-based vtable impl [WAS: Multi-table index ersatz?] On Wed, Mar 4, 2015 at 10:08 AM, Hick Gunter <hick at scigames.at> wrote: > Properly implemented virtual tables do support indexing, but you have > to write the code to support that yourself. > > I have personally implemented an index based on the fastbit package > which is ideally suited to retrieving large data sets via equality and > range constraints. > > See https://sdm.lbl.gov/fastbit/ Sounds interesting. Is this index suited to numeric datatypes, or are strings/blobs also supported? Can you share a little more details please? (if the code is not OSS and available somewhere to look at). This sounds very interesting. Thanks, --DD _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: hick at scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.
