On 28 Apr 2013, at 10:18pm, Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> wrote:
> Interesting, so sqlite3 is smart enough to actually move the blob instead > of copying and deleting? If it is the case it is indeed great. SQLite3 keeps all the data for a row together on disk. It rewrites the entire row any time any field in the row is changed. So if you make all your changes to a row in one UPDATE command, the old row will be read into memory, a new row will be composed in memory, then the new row will be written out to disk. Yes, by modern standards rewriting the whole row when any field changes is a questionable decision, but when SQLite was originally written it was intended as a tiny lite way of doing fast searches and nobody thought it would ever be used for huge databases of long rows. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users