SQLite Forum

Slow update table with large BLOB issue(solution)
Login
Eh, my mistake with checking second method "fastness"
I updated "name" field with the same text length, as soon as I increase "name" content length, second method become slow too. It does look like SQLite reposition all fields, including large BLOB with every update even if it doesnt include BLOB.