Re: Performance

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Performance
Дата
Msg-id 40DA7BE2.4040409@archonet.com
обсуждение исходный текст
Ответ на Performance  ("LuisH" <luish@lh.com.br>)
Список pgsql-general
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.

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: clusters and database instances
Следующее
От: Carlos Ojea Castro
Дата:
Сообщение: Re: psql