On 29 Jul 2011, at 3:34am, Roger Binns wrote: > On 07/28/2011 06:57 PM, Simon Slavin wrote: >> Would it improve the SQLite time if it was changed to strings instead of >> BLOBs ? > > Note that internally SQLite treats strings and blobs virtually identically. > Usually the same data structure and functions are used for them. At the > end of the day they are both a bag of bytes. > > The major difference is that strings also have an encoding which needs to be > taken into account should the bag of bytes need to be passed to a user > defined function, collation, return code etc.
So that's a "no". Actually I don't see how BLOBs can be used in an index anyway, since technically blobs have no ordering. But the nature of SQL is that if you can't sort on it you can't index it, and that would mean you couldn't search for a BLOB. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
