Uploading/Inserting large files: binary or path?

[predator]

Hey,

I'm doing a site where I can upload large power-point files/.ppt (up to 150 M😎.

My question is which is more smooth: To insert the files into blobs or upload the files on the server, entering only the path of the file in the db-table.
Either way I assume I'll have to change max_file_size and max_execution_time in the php.ini - file.

I was hoping to read some of your experiences when handling large files.

Also, I have already created a script that can insert the files into the database (using blobs) but I'm not sure how to do it ...when only inserting a path... so if anyone has a script or perhaps a link to such a script.. I'd be very grateful.

[planetsim]

Well to be smart never and i mean never upload files to the Database. Just have the link or even just the filename there.
Have the path to the file is as easy as doing this

path/to/$HTTP_POST_FILES['feildname']['name'] in the database feild.

Well ive never had to upload files that are over 1mb. It took long enough. I cant imagine too many people uploading files that are 1mb+ especially with DialUp they'd be there for ages.

Im not too sure on what method you should try on how to upload. But i guess you can try some trial attempts.

[predator]

thanks for your opinion.

Speed/connection is not a problem since this will only be used inside the company and they have a 10mbit or 100mbit connection.

[Weedpacket]

The point about not storing the files as blobs but as files (!) is still a good one, though. It's simpler, more convenient, and noticeably faster (even on 100Mbps connections).