John Meyer wrote:
Hi, I've got a client that I'm trying to convince to store the file path inAssuming MySQL is equally efficient to your filesystem at storing the file, and your filesystem is as efficient as MySQL at finding the file (use ReiserFS), then the issue comes down to maintainability and usability. In most cases, the files I want to store are easily accessible (NFS / SFTP / local), so machine name and/or filepath is sufficient for me and I don't have to maintain that data in the MySQL table space. On top of that, you don't have to worry about hitting maximum table sizes (in MyISAM tables) as quickly either and your files are still easily accessible from non-MySQL aware programs.
the database rather than the file itself into the database. Is there any
statistical data to show how much of a hit you take doing it as a BLOB vs. a
filepath?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
