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

Reply via email to