"He Shiming" <heshim...@gmail.com> wrote in message news:9bcdad5eb1464353a7ab4142edd91...@wheelerlab >> Consider replacing this query with a programmatic loop using blob >> API: >> >> http://sqlite.org/c3ref/blob_open.html >> >> or simply running a query like this: >> >> SELECT bin_content FROM FILE_CONTENT WHERE id = ?; >> >> with a new Id on every loop iteration. >> >> Igor Tandetnik >> > > Thank you for the pointers. It looks like both options require me to > implement the loop within C.
You are already running it anyway, to build the statement. > So is it true that running this loop > inside C would be faster than SQLite? Why don't you try it and see? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
