Large file uploads (100MB) with PHP/Oracle

[pablogosse]

Hi all. Quick question about large file uploads with PHP/Oracle.

I've been assigned to work on a project where I'm going to build a PHP front-end to an Oracle back-end. This all centres around E-Learning, and I'll need to allow people to upload Learning Objects (ie., video files, audio files, text documents, PowerPoint presentations, etc.) which will be inserted into the database as BLOBs, and then also allow people to group the Objects together into courses which could then be accessed.

What scares me is the fact that some of these objects could be up to, or more than, 100MB in size.

Has anyone here done any work with handling the upload of such large files with PHP?

Obviously I would need to alter the upload_max_filesize and max_execution_time values in php.ini to accomodate for this, but I'm wondering how well http uploads will actually work with objects of up to, or more than, 100MB.

Additionally, would there be any advantage/disadvantage of storing the files on the server with a reference to them in the database? This was a suggestion I received on another site, but right away I think of concurrency issues, and having to make sure that what's on the server is recorded in the database, and vice versa.

I'd be very interested to hear any opinions you folks might have.

Thanks very much in advance.

Pablo

[wil]

I have done uploads of over 100mb with PHP and MySQL. I have never had any problems with it before. I just changed the upload_max_filesize to 200mb and have never had problems. All of the files transfered are *.igs files (3-D CAD files). The other thing is all the customers are on T1 or better connects that we have to deal with. This helps dramatically.

Wil