Those measurements asume that you store each blob in a seperate file. So
the raw file access seems slower for smaller blob sizes.
If you use external blob storage do it in raw clusters like i suggested
in a previous post (size limit 32/64 MB) and store your blobs on page
boundaries (page size 4 k 8 k aso) this will always be faster cause you
have no b-tree pages which are always fragmented but sequential stored
image data.
Don't use file sizes larger than 32/64 MB because the pre fetch cache of
modern HD's can read the whole file even if you only ask for a port of
it and the fopen command will get slower when you open large files cause
you have to read the pagelist into an internal library buffer.
The given link is only true if you store each blob in a seperate file.
I use for my similar project raw cluster modell and thats x times faster
than storing image data in a b-tree organized database file.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
