liran ritkop <rejt...@bgu.ac.il> wrote: > Ok, I'll do it that way, it's a smart idea. > The question is, if i use files and not blob data, when i want to update the > data (this time the file, and not the blob field) it can lead to some kind > of fragmentation.
You are using Flash storage - why do you care about fragmentation? There are no disk head seeks to be concerned about. In fact, file systems designed for Flash often intentionally introduce fragmentation, for wear leveling. > Does anyone know, if sqlite know how to deal with it, if i > save it in a blob field? SQLite just uses the underlying file system operations. It has no control over fragmentation. > and if i save it in a file, so does ext4 filesystem > for example, deals with it better than sqlite? This question doesn't make much sense. SQLite database is a file. SQLite uses the file system to read and write to that file. It's up to the file system how this file is physically written to the disk. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
