Re: Implementing "thick"/"fat" databases - Mailing list pgsql-general

From Frank Lanitz
Subject Re: Implementing "thick"/"fat" databases
Date
Msg-id 4E2D27C9.5080709@frank.uvena.de
Whole thread Raw
In response to Re: Implementing "thick"/"fat" databases  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: "Markus Wollny"
Date:
Subject: Query, usually running <300ms, sometimes hangs for hours
Next
From: Sim Zacks
Date:
Subject: Re: Implementing "thick"/"fat" databases