Hi,
I have a question regarding the retrieval of BLOBs.
Assume you have a table mytable(id, blob) and the page size is 1k.
If we now carry out an sql-query like "select blob from mytable where id=4711"
and the blob size is 100k.
Am I then correct that the pager asks 100 times for a page of size 1k (going
through the linked list of overflow pages)
and that in whatever virtual file system, we do 100 times a seek operation to
the currently requested page.
Is this correct or am I here mistaken?
Best Martin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
