On Fri, Jun 29, 2012 at 6:40 PM, Nico Williams <n...@cryptonector.com>wrote:
> On Fri, Jun 29, 2012 at 5:24 PM, Richard Hipp <d...@sqlite.org> wrote: > > varint+value does not sort BLOBs in lexicographical order. > > > > Not having a distinct terminator for the BLOB means that two BLOBs where > > one is a prefix of the other might not compare correctly. > > Would 31-bit encoding help? > Maybe. But you know: How often do people use BLOBs as keys? What other SQL engines other than SQLite even allow BLOBs as keys? Are we trying to optimize something that is never actually used? Note that the data encoding<http://www.sqlite.org/src4/doc/trunk/www/data_encoding.wiki>for BLOBs (used in the overwhelmingly common case of when the BLOB is not the key) does have a simple size+content format. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users