-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk4yHCYACgkQmOOfHg372QQ7ugCgm+ZBxtQJdpeLc/+ibVX8yVD9 8cEAn0GtwGRnH9hQfc8JuQZ580vP3Ia7 =oPtH -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users