RE: Some BLOB help please.

2004-06-23 Thread emierzwa
[mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:01 PM To: Justin Crone Cc: [EMAIL PROTECTED] Subject: Re: Some BLOB help please. Justin Crone wrote: snip So as I said, I am rather pleased with the performance and the ease at which I was able to get this up and running. However

Re: Some BLOB help please.

2004-06-23 Thread Keith Ivey
[EMAIL PROTECTED] wrote: You might save some space if you compress() before storing. Depending on file content I'm seeing 0-50% savings? Good idea, but note that COMPRESS() and UNCOMPRESS() weren't introduced until MySQL 4.1.1. With earlier versions you may be able to compress and uncompress in

Some BLOB help please.

2004-06-22 Thread Justin Crone
Hello All, I have been reading hundreds of posts and sites for information regarding BLOBs in MySQL. So far I have not found an answer to my question, so I pose it to you fine people. :) A little background first. I have a web server that uses PHP to retrieve documents in PDF format for

Re: Some BLOB help please.

2004-06-22 Thread Michael Stassen
Justin Crone wrote: snip So as I said, I am rather pleased with the performance and the ease at which I was able to get this up and running. However The problem is I do have limits, and one of those being disk space. Those 10,000 files are taking up 21 GB of space in the database. However