CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 File Storage - In database or file system??

Print topic Send  topic

Author Message
bowtellj

Posts: 65
Posted: 10/22/2006, 3:51 PM

I will be creating an online repository of files ranging in size up to 5mb. Should I store these in the database or file system.....

If I choose the file system I believe I will need to hash/rename the file to ensure it is unique. Is this easy to do?

Thanks
_________________
Thanks

James

Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
View profile  Send private message
Edd


Posts: 547
Posted: 10/22/2006, 7:56 PM

The storage of large chunks of data in a database is a big NO! Most databases will handle it but it increases I/O time, blocking factors, backups, log files, etc all factor it to being a bad idea.

Renaming is easy to do.

Depending on your environment, you may want to test 3rd party upload components as 5mb is a huge transfer hit.

Edd


_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.