Re: Performance

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
> Richard Huxton
> Sent: Thursday, June 24, 2004 12:00 AM
> To: LuisH
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Performance
>
>
> LuisH wrote:
> > Question about Performance:
> >
> > What about access sounds (WAV or VOX) from filesystem or from Blob
> > Database ???????????? Whish performance can I expect on each case ??
>
> Filesystem access should always be faster than through the
> database. If
> it isn't you should get a new filesystem.
>
> You need to ask yourself:
> 1. Do I want transactional control over updates to these
> sounds? 2. Do I always want to store the files on the same
> machine as the database? 3. Is it easier/more difficult to
> read/download files vs access via the
> database connection.

It isn't always that simple. What if you need to find them by date?
What if you need to search by title among millions of them. Often (as
well) file systems slow down when you put hundreds of thousands or
millions of files in a directory.

Database is preferrable if you want to use SQL syntax to search for the
blobs based upon criteria.

If you have a small number of static things, then files are better.