Received: from qmsql.netservers.net (hpmail2.netservers.net [209.196.128.168]) by postgresql.org (Postfix) with SMTP id 94D56476547 for ; Thu, 11 Apr 2002 09:20:09 -0400 (EDT) Received: (qmail 65960 invoked from network); 11 Apr 2002 13:19:57 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail2.netservers.net with SMTP; 11 Apr 2002 13:19:57 -0000 Message-ID: <003801c1e15a$c03c5450$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: , Subject: Transactional vs. Read-only (Retrieval) database Date: Thu, 11 Apr 2002 09:14:02 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0035_01C1E139.38DCBB60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/441 X-Sequence-Number: 23157 This is a multi-part message in MIME format. ------=_NextPart_000_0035_01C1E139.38DCBB60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'd like to get some opinions if there are any benefits (i.e. in terms of p= erformance) of creating two separate databases, one for transactions (inser= t, update, delete) and the other one is for retrieval/search (select). Thanks in advance for your input. Sam _________________________________________________ Expand your wireless world with Arkdom PLUS http://www.arkdom.com/ ------=_NextPart_000_0035_01C1E139.38DCBB60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I'd like to get some opinions if there are= =20 any benefits (i.e. in terms of performance) of creating two separ= ate=20 databases, one for transactions (insert, update, delete) and the other= one=20 is for retrieval/search (select).
 
Thanks in advance for your input.
Sam
_________________________________________________
 Expand = your=20 wireless world with Arkdom PLUS
 http://www.arkdom.com/
= ------=_NextPart_000_0035_01C1E139.38DCBB60--