Blob limitations

I'm trying to do blob storage inside the database (and am indeed 
aware of the advantages and disadvantages). If I want to put a 1G 
object into the database, I was under the mis-impression that I 
could do this via something like uploading the file 1 (largish) 
chunk at a time (i.e. set image=concat(image,?) where id = ?), but 
I found that that statement still blows out on max_allowed_packet. 
Increasing the packet size led me to a memory error (dbd::mysql::st 
execute failed: out of memory).

Given all this, I'm either missing something, or there really is no 
purpose to largeblob or largetext, as one can't fill them from. 
Before I redo my tables to make the chunks explicit, am I missing 
something?

Thanks, and sorry for the petulant and frustrated tone. It's just 
that I'm... frustrated and petulant


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]