Re: Implementing "thick"/"fat" databases

Поиск
Список
Период
Сортировка
От Frank Lanitz
Тема Re: Implementing "thick"/"fat" databases
Дата
Msg-id 4E2D27C9.5080709@frank.uvena.de
обсуждение исходный текст
Ответ на Re: Implementing "thick"/"fat" databases  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Am 25.07.2011 10:12, schrieb Pavel Stehule:
> 2011/7/25 Frank Lanitz<frank@frank.uvena.de>:
>> Am 22.07.2011 21:15, schrieb Karl Nack:
>>>
>>> to move as much business/transactional logic as
>>> possible into the database, so that client applications become little
>>> more than moving data into and out of the database using a well-defined
>>> API, most commonly (but not necessarily) through the use of stored
>>> procedures.
>>
>> Beside the points already mentioned, doing this will might cause bottle
>> necks if you have complicated transactions as the DB-cluster might can not
>> be scaled as good as maybe a farm of application server could be done.
>>
>
> Yes, and no - this can decrease network overhead, can decrease a data
> conversion overhead. Sometimes I was surprised how much time I got
> with moving to stored procedures.

Yep. Its always depending on what you are doing I guess.

Cheers,
Frank

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

Предыдущее
От: "Markus Wollny"
Дата:
Сообщение: Query, usually running <300ms, sometimes hangs for hours
Следующее
От: Sim Zacks
Дата:
Сообщение: Re: Implementing "thick"/"fat" databases