| From: | "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Transactional vs. Read-only (Retrieval) database |
| Date: | 2002-04-11 13:14:02 |
| Message-ID: | 003801c1e15a$c03c5450$110a010a@headquarters.wcgroup.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
I'd like to get some opinions if there are any benefits (i.e. in terms of performance) of creating two separate databases, one for transactions (insert, 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2002-04-11 13:33:59 | Re: Critical performance problems on large databases |
| Previous Message | Nigel J. Andrews | 2002-04-11 13:05:07 | Re: Critical performance problems on large databases |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2002-04-11 13:28:32 | Re: REPOST: Trouble with SQL conversion |
| Previous Message | cnliou | 2002-04-11 11:09:18 | Problem With A Rule |