On 17/02/12 14:51, Frank Chang wrote:
I ran some tests today and found that sqlite3_blob_reopen is significantly
faster than sqlite3_blob_open.
Have you read the documentation?
http://www.sqlite.org/c3ref/blob_reopen.html
sqlite3_blob_reopen only works when you already have a blob handle open that
you no longer want to use, and can only be used to point to a different row
of the same table.
The functions are complementary to each other, not alternatives. Your
observations match the documentation as expected.
Do you have a question?
Roger
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
