Hi,
In this particular case, I need to have the same files on different
servers all over the world, and doing mirroring over SSH is a real pain.
It would be so much easier to have everything in the same table and check
for the update time.
Consider feeding up the files via Servlet based URL's and you need not sync.
And you will be table to tunnel through firewalls.
Seems like those big files are either getting split in several pieces as
Wolfgang suggested (I get rather good performance - but I'm a bit scared
to fill the table with > 80GB of files), either we'll stick to what's
there now, even if it's not too satisfying.
You're going to run into other problems depending on your platform. Look
into filesize limits, which your table will run into if you are writing
many huge files.
7 messages in com.mysql.lists.javaRe: Inserting into BLOB, Memory consu...