Looking at the MySQL API I'd have to agree that there's no obvious way of doing this efficiently. I don't see anything equivalent to, for example, Oracle's "piecewise LOB fetch" functionality, or other ways of "streaming" the BLOB rather than fetching/updating all in one go.
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. -- Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool -----Original Message----- From: Stephen Collyer [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:25 To: dbi-users@perl.org Subject: MySQL BLOB: random access via DBI ? I suspect that I know the answer already but .. does DBD::mysql (or the MySQL API for that matter) support random access to BLOB types ? i.e. the ability to select/insert a BLOB via a serious of small queries, as opposed to the memory intensive approach of selecting/inserting the total contents of the column in one query. I've found nothing useful via Google, or the MySQL site though what I can see in the mysql API documentation leads me to believe that this isn't supported at all. -- Regards Stephen Collyer Netspinner Ltd
