RE: Blob implementation question

2013-03-13 Thread Rick James
A lot of details are missing... Engine: MyISAM? InnoDB? other? Let's see the SELECT. If InnoDB, let's see the transaction, if it is part of such. If InnoDB, which (COMPACT, etc) are you using. You are asking about a single row with the 500MB, correct? In general, each reques

Re: Blob implementation question

2013-03-13 Thread Adam Ilardi
Engine: MyISAM? InnoDB? other? InnoDB Let's see the SELECT. select bytes from table_name where id = %d If InnoDB, let's see the transaction, if it is part of such. It's a single query If InnoDB, which (COMPACT, etc) are you using. Not sure You