On 06.03.2011, at 14:22, Alexey Pechnikov wrote: > 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? >
Hey Alexey, couldn't you just define any hash function you like using SQLite's interface as outlined here? http://www.sqlite.org/c3ref/create_function.html /eno _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users