
>     As  a  rule  of  thumb,  online  applications  that hold open
>     transactions during user interaction  are  considered  to  be
>     Broken  By  Design  (tm).   So I'd slap the programmer/design
>     team with - let's use the server box since it doesn't contain
>     anything useful.

We have a database system here, and not an OLTP helper app.
A database system must support all sorts of mixed usage from simple 
OLTP to OLAP. Imho the usual separation on different servers gives more
headaches than are necessary.

Thus above statement can imho be true for one OLTP application, but not 
for all applications on one db server.

Andreas

Tue, 22 May 2001 10:06:54 +0200
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: AW: Plans for solving the VACUUM problem