It does make the database larger.. as far as overhead... As you can't just store the file as a blob.. You'll need some referencing data in order to find it, and restore it back out of the database..
I just checked out my database (100's of files) which has: Total file size: 1765.34MB Mysql files are: -rw-r----- 1 mysql mysql 23216 Feb 27 03:49 file.MYD -rw-r----- 1 mysql mysql 10240 Feb 28 03:50 file.MYI -rw-r----- 1 mysql mysql 8756 Feb 23 2003 file.frm -rw-r----- 1 mysql mysql 1808037152 Feb 27 03:53 filedata.MYD -rw-r----- 1 mysql mysql 400384 Feb 28 03:50 filedata.MYI -rw-r----- 1 mysql mysql 8614 Feb 23 2003 filedata.frm So it's not too bad as far as overhead.. On Thu, 11 Mar 2004, Eve Atley wrote: > > >Is there an advantage to storing the PDFs directly into the database? > > I'm also curious how large this would make a database. Is there any space > saved through this method, or would they still be the same size as the > original PDF? > > - Eve > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
