Hello Simon, Monday, August 3, 2009, 8:28:03 PM, you wrote:
SD> 2009/8/3 sorka <sorka95...@gmail.com>: >> >> Hi. I have a table that stores pieces of an image as a bunch of blobs. I get >> the pieces out of order and store them in a table until I get all of the >> pieces I need. I then want to assemble them in order and store the resulting >> complete image in in another table entirely. >> >> Is there a smart way to go about this so that memory use is limited? A >> select and order by the part number will return each blob in order. Is there >> a way to use concat to build up the final blob in the other table without >> having to store all the pieces in memory first? SD> use blob incremental io: SD> http://www.sqlite.org/c3ref/blob_open.html >> >> Thanks. >> -- SD> Rgds, SD> Simon SD> _______________________________________________ SD> sqlite-users mailing list SD> sqlite-users@sqlite.org SD> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Why assemble them at all? You have the order the blobs appear. When it's time to pull the completed blob out of the DB, just read them in order. -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
