Welcome! Log In Create A New Profile

Advanced

Re: Serving static file dynamically ...

Marcus Clyne
March 24, 2009 04:50PM
Cliff,

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.

The limits on blob size are based on MySQL's limits, which glancing at
http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html appears
to be 4GB for LONGBLOB (which all data in PBMS is stored as).

The**** '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.

Serving just a few thousand files from the filesystem, though, isn't
going to put it under stress.

Cheers,

Marcus.


Cliff Wells wrote:
> On Tue, 2009-03-24 at 12:06 -0700, Brice Leroy wrote:
>
>> 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.
>>
>
>
> 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
>
>
>
>
>
>
Subject Author Posted

Serving static file dynamically ...

Brice Leroy March 24, 2009 02:05PM

Re: Serving static file dynamically ...

Jean-Philippe Moal March 24, 2009 02:37PM

Re: Serving static file dynamically ...

Brice Leroy March 24, 2009 02:47PM

Re: Serving static file dynamically ...

Marcus Clyne March 24, 2009 02:49PM

Re: Serving static file dynamically ...

Marcus Clyne March 24, 2009 03:51PM

Re: Serving static file dynamically ...

mike March 24, 2009 04:12PM

Re: Serving static file dynamically ...

Marcus Clyne March 24, 2009 04:55PM

Re: Serving static file dynamically ...

Brice Leroy March 24, 2009 05:35PM

Re: Serving static file dynamically ...

mike March 24, 2009 05:56PM

Re: Serving static file dynamically ...

Brice Leroy March 24, 2009 06:17PM

Re: Serving static file dynamically ...

Marcus Clyne March 25, 2009 02:07PM

Re: Serving static file dynamically ...

Brice Leroy March 25, 2009 02:49PM

Re: Serving static file dynamically ...

Marcus Clyne March 25, 2009 03:34PM

Re: Serving static file dynamically ...

Brice Leroy March 25, 2009 05:28PM

Re: Serving static file dynamically ...

Juan Fco. Giordana March 27, 2009 03:03PM

Re: Serving static file dynamically ...

Yordan Georgiev March 27, 2009 03:26PM

Re: Serving static file dynamically ...

Brice Leroy March 27, 2009 03:39PM

Re: Serving static file dynamically ...

Adam Zell March 25, 2009 03:02PM

Re: Serving static file dynamically ...

Cliff Wells March 24, 2009 04:09PM

Re: Serving static file dynamically ...

Marcus Clyne March 24, 2009 04:50PM

Re: Serving static file dynamically ...

Brice Leroy March 24, 2009 05:41PM

Re: Serving static file dynamically ...

Marcus Clyne March 25, 2009 02:11PM

Re: Serving static file dynamically ...

Brice Leroy March 24, 2009 03:26PM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 263
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready