> -----Original Message-----
> From: Ben Holness [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
...
> My question is this: Would it be more efficient to have each entry in the
> list stored in this table in the database, or would I be better
> off having a
> reference to a file that is stored on the hard disk?
If you mean efficient in terms of performance, the answer depends on how big
the data is that would go in the files v. a database record, and how often
they'll be accessed. If you mean more efficient in terms of disk space,
there's probably little difference if the files are large, but a big
difference if there are lots of little ones. How much difference for the
latter depends on what file system you're using.
In any event, you'll probably have to experiment. If you're talking about a
lot of relatively small files, putting the data into database fields will
probably win.
Nick
---------------------------------------------------------------------
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
