Message-Id: <10592.114906@fatcity.com> From: "Andrey Bronfin" Date: Thu, 17 Aug 2000 23:40:40 +0200 Subject: capacity issues This is a multi-part message in MIME format. ------=_NextPart_000_00A5_01C008A4.8D38E9F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear list ! I have a very urgent question : I have a mixed-type application here , it's both OLTP & DataWarehouse . I need to plan the machines for production . I have 3 options : a) Create 2 databases - one for OLTP and one for the batch processing = - reports and put them on 2 different machines ( Sun E 220 with 1 CPU = each ) . b) Create the same 2 DBs and put them on one Sun E 220 machine with 2 = CPUs . c) Create 1 database to host all the tables of both the OLTP & = reports parts of the application . Would U please give some guideness on the above , some pros & cons for = each approach . Basically there are 2 decisions to take :=20 is it better to have one mixed database or 2 different DBs=20 and=20 in case U have 2 DBs , is better to put them on one machine or on 2 = different machines . Thank U VERY much in advance . Every tip is VERY appreciated . Andrey Bronfin VisualTop.com +972-3-5275757. ------=_NextPart_000_00A5_01C008A4.8D38E9F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear list !

I have a very urgent question = :

I have a mixed-type application here , = it's both=20 OLTP & DataWarehouse .

I need to plan the machines for = production=20 .

I have 3 options :

a) Create 2 databases - = one for OLTP=20 and one for the batch processing - reports and put them on 2 = different=20 machines ( Sun E 220 with 1 CPU each ) .

b) Create the same 2 DBs = and put them=20 on one Sun E 220 machine with 2 CPUs .

c) Create 1 database = to host all=20 the tables of both the OLTP & reports parts of the application=20 .

Would U please give some guideness on = the above ,=20 some pros & cons for each approach .

Basically there are 2 decisions to take = :=20

is it better to have one mixed = database or 2=20 different DBs

and

in case U have 2 DBs , is better = to put them=20 on one machine or on 2 different machines .

Thank U VERY much in advance = .

Every tip is VERY appreciated = .

Andrey=20 Bronfin
VisualTop.com
+972-3-5275757.