I am appending blocks of binary data to an existing BLOB in a database. The blocks are coming at me in 1000 to 3000 bytes chunks and the BLOB can grow to a few meg easily. I am using the sql command (from PHP):
UPDATE MyTable SET MyBlobField=CONCAT(MyBlobField,"--escaped binary data here--") This update gets significantly slower as the BLOB grows in size. I believe the server may actually be reading the entire BLOB out of the database and writing it back in. Is there a smarted way to APPEND in instead of CONCAT? I can't find it. Thank You, Bill Clery --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php