On 21 Sep 2011, at 1:19am, Richard Hipp wrote: > 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.
Looking at the '10k' column in your graph, do you have any idea why the figures seem destined to climb as the page size climbs, but then drop severely for the last two rows ? It's evident in the next column too, but not as obvious. I looked at some image files we keep at work which are passport-style photos of people. They're about 225k. So at default page size for our computers, it's around three times as fast to keep the pictures as files, and store just the filename. Wow. That's assuming performance on Macs is about the same as performance under Linux. Pretty identical hardware and OS, but radically different file system. Might give very different results. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
