Re: Some BLOB help please.

2004-06-22 Thread Michael Stassen
Justin Crone wrote: 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 the ac

RE: Some BLOB help please.

2004-06-23 Thread emierzwa
--- From: Michael Stassen [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: > > So as I said, I am rather pleased with the performance and the ease at > which I was able t

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 yo