Sqlite does not has ability to compress indices. There is huge performance problem with populating a database with indexed text or blob fields. But we can emulate indices compression by using index on hashed field (and populate the hash field by trigger as example). I think one or more hash functions may be included into core SQLite.
Note: I use the public domain licensed murmur hash algorithm (as extension) but this need custom build of SQLite or external extension. Does anybody has the same problem? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
