in reply to Huge Table of BLOBs or Binary Flat-File Database?
How about creating a three column table - with the key (filename) in the first column, the first 1k or so of the blob in the second column and the full blob in the third column. Seems like you could arrange it so that you very rarely if ever had to search the full blob. Then you could arrange your queries so you never gather more than x rows at a time (where x is the size of the blobs times whatever your RAM can manage).