Hello! I want to build a big DB file (about 16 GB). now, The DB will be updated all the time, row by row. I know that SQLIte will automatic define the value of the cell by it's value size. I think that this can cause that when the cell is updated from 8 bytes to 4 bytes (or vice versa ) , it will cause fragmentation. Is it true? And is it a better approach to build the DB file in the beginning in such a way that every cell will contain the largest value that i use, and later on, when maybe updated to a smaller cell, it won't make fragmentation? -- View this message in context: http://old.nabble.com/Large-DB-files-fragmentation-tp32146059p32146059.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
