asmith
Oct 8 2008, 10:24 AM
Hey guys
I will be running a game site, with a very very big archive. Each day maybe 20-100 file will be uploaded.
I wanted to know which way is the best in these cases.
I save the file in the mysql, or just save them normally in a folder on the server?
don't know the benefits of them.
Thanks
Darin McGrew
Oct 8 2008, 11:30 AM
It's more work for the server to retrieve large static files from a database than to retrieve them from a filesystem.
asmith
Oct 8 2008, 02:21 PM
What's the benefits of saving it in the mysql database?
Brian Chandler
Oct 9 2008, 12:01 AM
If customers are uploading files which your server program does not expect to process the internal structure of, then there is no advantage in storing the whole byte stream (text) of the file in the DB. But of course you should have a db table to record the details of the file (including original name, and the necessarily unique name you have saved it as).
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.