Hi folks. I'm storing files in a BLOB table for a number of reasons for my web app, and I'm trying to break up uploads so I insert smaller chunks (my app imposes restrictions on memory usage, so reading the whole file at once and doing an insert doesn't work).
What I do is insert the record, then call a series of UPDATE queries on the record concating the new chunk with the existing blob column. The problem I'm having is that the size of the blob column is WAY off for larger files (2MB or so). My app reports that the entire file was read properly, but not all of it was inserted properly into the DB. Any ideas on why this is happening? Any suggestions for alternatives? Storing the files on the filesystem is not an option for me. Thanks I'm using 3.23.36 (linux RedHat) with MyISAM tables. -jim kutter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
