<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Cliff,<br>
<br>
The limit mentioned there is just for the JDBC driver, and is due to
the limits of JDK 1.5.x. You don't have to use the JDBC driver for
PBMS. There's a direct C API, you can use any MySQL APIs to input data
and and you can 'upload' the blobs via HTTP.<br>
<br>
The limits on blob size are based on MySQL's limits, which glancing at
<a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html">http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html</a>
appears to be 4GB for LONGBLOB (which all data in PBMS is stored as).<br>
<br>
The<strong></strong><font size="3"><strong></strong></font> 'problems'
I was thinking about, though, was with the actual time/overhead it
takes to load a file that big into a db. The main advantage I see for
PBMS over static files is when you have a very large number of them
(hundreds of thousands or more), because then you avoid having large
extra storage capacity for metadata and you don't ask the filesystem to
deal with a huge number of files.<br>
<br>
Serving just a few thousand files from the filesystem, though, isn't
going to put it under stress.<br>
<br>
Cheers,<br>
<br>
Marcus.<br>
<br>
<br>
Cliff Wells wrote:
<blockquote cite="mid:1237925396.4523.20.camel@portable-evil"
type="cite">
<pre wrap="">On Tue, 2009-03-24 at 12:06 -0700, Brice Leroy wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Marcus,
Thank you for you advice but I think this solution will not work for
me. As I wrote on my previous email, I'm going to serve HD video
content which is going to be more than 1GB.
</pre>
</blockquote>
<pre wrap=""><!---->
A quick perusal of the docs turned this up:
12.3. Limitations
The current implementation is based on JDK 1.5.x, which only allows for
lengths in setBinaryStream(), setAsciiStream() and setBlob() of type
'int'. This means that the maximum BLOB size that can currently
permitted is 2GB.
Regards,
Cliff
</pre>
</blockquote>
<br>
</body>
</html>