Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Tim Watts Newsgroups: comp.databases.mysql Subject: Re: Can MySql database store images? Followup-To: comp.databases.mysql Date: Sun, 24 Apr 2011 21:01:55 +0100 Organization: A noiseless patient Spider Lines: 48 Message-ID: References: <4db4336c$0$81484$e4fe514c@news.xs4all.nl> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7Bit Injection-Info: mx03.eternal-september.org; posting-host="6oIlEBqCjOm0MjsSUEk5CA"; logging-data="14637"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+SBsvsRapTdZqMtfBOMWh5zpdDUcrtLh8=" User-Agent: KNode/4.4.6 Cancel-Lock: sha1:IYf1W7dktZ2AZNysetTVeLJd3W8= Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:620 Jerry Stuckle wrote: > On 4/24/2011 2:07 PM, Tim Watts wrote: >> The Natural Philosopher wrote: >> >> >>> The only advantages of a flat file system are that any incompetent >>> programmer can make it work. >> >> It may also be the case that you are using a shared/hosted MySQL host >> which is not designed for bulk data storage but you do have an additional >> filsesystem to one side. >> >> >> > > I have never seen a MySQL host which isn't designed for storing data. Please quote me accurately Jerry, - I said "bulk data" not "data". In two of my previous jobs, we had a shared db host for lots of people. The DB host had one DB instance per user, but the host itself was shared amongst 500 people in one case (students) and in another case, 100 people (general ad hoc research). The host was well managed (automated backups etc) but it was specifically *not* its purpose to store more than a few hundred MB per user as the total capacity of the machine was not capable. I could see this being an issue with some genral purpose hosting solutions. > And I've never seen a shared host with additional filesystems. Conversely it's pretty standard where I work. > You get > what you've been given. > True - which is why the OP should consider both sides. But the debate is useful. Cheers, Tim -- Tim Watts