4 messages in com.mysql.lists.javaRe: Blob streamability| From | Sent On | Attachments |
|---|---|---|
| Ruben Malchow | 11 Aug 2006 05:20 | |
| Mark Matthews | 14 Aug 2006 07:45 | |
| Robert DiFalco | 14 Aug 2006 09:03 | |
| Marc Herbert | 30 Aug 2006 05:21 |
| Subject: | Re: Blob streamability |
|---|---|
| From: | Mark Matthews (ma...@mysql.com) |
| Date: | 08/14/2006 07:45:08 AM |
| List: | com.mysql.lists.java |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Ruben Malchow wrote:
hello list,
i stumbled across the comments in /com/mysql/jdbc/Blob.java and it confirmed my suspicions: it really is nothing but a byte array containing all the data of the blob. so basically, the streaming from and into the db are still limited by the available memory ... which is not really the point of a blob.
is there any information as to when streaming is going to be real, and when this implementation of java.sql.Blob will actually provide methods that can modify a blob without loading all it's data into memory first? the comments are a bit vague about this ... and it would really be a great improvement!
.rm
Ruben,
The issue is that the problem is not solvable in the client. There needs to be server-side functionality added (LOBs in particular) as well as the streaming of reads of blobs (you can already stream data in server-side prepared statements _to_ the server, and the driver already does this). As far as I know, this functionality is not on the development roadmap for the server.
-Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFE4IyKtvXNTca6JD8RAg7ZAKCenZLUPNZQGBVMMYeov/Q2GZGD1QCggEwM 57+SuiSo9oKkoGbOyb4QpMw= =cZ3c -----END PGP SIGNATURE-----