MySQL Forums
Forum List  »  PHP

Re: Proper storage of web content with PHP/MySQL
Posted by: Jay Pipes
Date: August 11, 2005 08:19PM

I tend to go with the hybrid approach as well; storing *large* files and binary objects in the filesystem, and everything else (including text-based entries for things like blog posts, news feeds, forum posts, etc) in the database. The only exception I've had to this rule is when the application has had a) very real load balancing issues where we didn't want to put copies of images/files on multiple web servers in the farm, and b) when security is a prominent concern and the client wants a custom-rule security implementation for file-sharing.

I'm not quite sure I understand what you mean by "bidirectional". Do you mean that a file can be accessed or related to more than one entity? If so, I don't see why this prohibits the file/image from being stored in the filesystem.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Written By
Posted
Re: Proper storage of web content with PHP/MySQL
August 11, 2005 08:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.