Re: [sqlite] Merging blobs on disk without taking up memory???

2009-08-09 Thread John Stanton
If you map each BLOB into virtual memory and create an anonymous mapped file to receive the concatentaed result toy can handle the blobs without using your stack and heap memory. Of course this assumes that you are using a POSIX OS (e.g. Windows or Unix/Linux). sorka wrote: > Hi. I have a

Re: [sqlite] Merging blobs on disk without taking up memory???

2009-08-03 Thread Teg
Hello Simon, Monday, August 3, 2009, 8:28:03 PM, you wrote: SD> 2009/8/3 sorka : >> >> 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

Re: [sqlite] Merging blobs on disk without taking up memory???

2009-08-03 Thread Simon Davies
2009/8/3 sorka : > > 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

[sqlite] Merging blobs on disk without taking up memory???

2009-08-03 Thread sorka
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