SQLite Forum

Setting non-binary columns to null in a table with a binary column populated with data creates free space and a larger file
Login
Yes, with the database for our application, the long fields are the last field in each table and the file size continues to grow when the update command is executed.

From reading the previous replies, it seems we have to change our schema design to store the long fields on a separate table to get around this issue.

Thanks for looking into this and providing a detailed explanation of what is going on behind the scenes.