Stephen Collyer wrote: >Andy Hassall wrote: >> For fetching I suppose you could hack it together with SUBSTR (but is >> it valid to use that on binary data?). I doubt it'd be very friendly >> to the server, although it would reduce the client memory issues. > >Are you referring to Perl's substr() or MySQL's SUBSTRING() ? Either way, I'm not sure that >it would make much difference. This is from the "How mysql uses memory" page of the mysql >docs: > >>For each table having BLOB columns, a buffer is enlarged dynamically >>to read in larger BLOB values. If you scan a table, a buffer as large >>as the largest BLOB >value is allocated. > > From that, I get the impression that mysql is pretty naive in terms of memory >minimization w.r.t BLOBs.
I was thinking MySQL's substr (alias of substring), but from what you say above, it won't help. -- Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
