Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From: Tim Watts <tw@dionic.net>
Newsgroups: comp.databases.mysql
Subject: Re: Can MySql database store images?
Followup-To: comp.databases.mysql
Date: Wed, 27 Apr 2011 12:32:41 +0100
Organization: A noiseless patient Spider
Lines: 27
Message-ID: <qfbl88-4us.ln1@squidward.dionic.net>
References: <npqdnTD4r-AUWi7QnZ2dnUVZ5qudnZ2d@giganews.com> <ip15se$33s$1@dont-email.me> <55md88-7pb.ln1@squidward.dionic.net> <ip1c0d$dde$1@dont-email.me> <ip21sn$cb8$1@dont-email.me> <ip23aj$v3q$2@dont-email.me> <ip361h$ml9$1@dont-email.me> <68mf88-4l5.ln1@squidward.dionic.net> <ip57sl$rc5$1@dont-email.me> <ip6jp4$kca$1@dont-email.me> <ip7uo6$u89$1@dont-email.me> <ip8gb0$2ni$2@news.albasani.net> <ip8rs3$tak$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
Injection-Info: mx03.eternal-september.org; posting-host="PfteNUsu9gxPcp7CbOxONA"; logging-data="8709"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/22lyQHrpunqn251TwXK9raqfld0zDNYI="
User-Agent: KNode/4.4.6
Cancel-Lock: sha1:BBfPc2NllPVNDCCKsOZJ6bwmt8c=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:698

Norman Peelman wrote:

> The Natural Philosopher wrote:
>> Norman Peelman wrote:
>>> Doug Miller wrote:

>>> Dump file (w/images) = 29.8MB
>>> Dump file zipped = 1.7MB
>>>
>>>
>> It is seldom possible to compress images more than they are already
>> compressed.
>> 
>> So I still think you have made a mistake.
> 
>    It's a dump file, the images are in textual format (base64?) not
>    binary.
> 

Yebbut: if the total images are 460*5.3kB = 2.4MB of pure image data.

You wouldn't normally expect those to be very comprssible by ZIp from JPGs, 
especially if you have already gone through another encoding (ie ASCII).

It's not impossible but it seems a bit close...

-- 
Tim Watts