RE: Blob streamability
"Robert DiFalco" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
This is one of the most disturbing things about the server and IMO really sets it apart from most other enterprise class database servers. No matter how many concurrent sessions there are, not matter how large the LOB data, all LOB bytes must be completely read into memory before being written to the table and as you point out, read completely into memory when retrieving it from a table. I'm not sure why streaming these bytes to and from disk isn't just an obvious high-priority item for the roadmap. I hear people complaining about this all the time. R. -----Original Message----- From: Mark Matthews [mailto:[email protected]] Sent: Monday, August 14, 2006 7:46 AM To: Ruben Malchow Cc: [email protected] Subject: Re: Blob streamability -----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----- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]