On 8/3/18, Abroży Nieprzełoży <abrozynieprzelozy314...@gmail.com> wrote: > > I would also consider keeping the largest files external to the > database. https://www.sqlite.org/intern-v-extern-blob.html >
See also https://www.sqlite.org/fasterthanfs.html Yes, it is a little faster to store larger files directly in the filesystem. But not that much faster. And it is certainly convenient to have all your content in one place and to have transactional reads and writes. So, unless there is a compelling need for an extra 10% performance, I would argue for keeping all content in the database file. FWIW, I also think you should store your files as a single big blob and parse out the individual lines using C++ code when you need that. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users