Blob limitations

Blob limitations

am 23.06.2010 23:13:56 von wonk

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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org