Hi Dan,
The problem with BLOB is that traditionally MySQL, along with a lot of other
databases, is not designed to handle them very well. The BLOB data is passed
between the client and server as if it where the same as any other data.
This results in large memory use by both the client and server
At 07:08 AM 7/13/2009, you wrote:
Hello,
I'm developing a web application that requires to store large files in a
MySQL database. The files can range up to 2Gb.
In my understanding the upper limit for the SQL queries (thus insert
queries) is 1GB. I'm trying, for the time being, to upload files o
Redesign. Do NOT store files in a database. The kind of database that's good
a storing files, is more commonly known as "filesystem".
On Mon, Jul 13, 2009 at 2:08 PM, Daniele Development-ML <
daniele@googlemail.com> wrote:
> Hello,
> I'm developing a web application that requires to store la
Hello,
I'm developing a web application that requires to store large files in a
MySQL database. The files can range up to 2Gb.
In my understanding the upper limit for the SQL queries (thus insert
queries) is 1GB. I'm trying, for the time being, to upload files of sizes
around 65MB, but I still get