If you are storing large BLOBs in SQLite, can you read them faster if they are stored directly in the database file, or can you get to them quicker if you store just a filename in the database and read the BLOB content from a separate file?
We did some experiments to try to answer this question, and the results seemed interesting enough to share with the community at large. Bottom line: On Linux workstations, it is faster to store BLOBs in the database if they are less than about 100KB in size, and faster to store them in a separate file if they are larger than about 100KB. This is on Ubuntu with EXT4 and a fast SATA disk - your mileage may vary with different operating systems, filesystems, and hardware. The complete report is here: http://www.sqlite.org/intern-v-extern-blob.html -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
