Re: HW requirements / high INSERT/UPDATE rates / main-memory DB
Date: Wed, 24 Mar 1999 23:08:05 GMT
Message-ID: <pfeK2.24997$FZ5.7703_at_news.rdc1.sfba.home.com>
If you are looking for a specif hardware, you can use HP-UX or SUN with a good amount of memory and disk space.
as far as achieving your goals you can use CAT(chunk at a time) set process to do this (unless otherwise you really need to do RAT(row at a time).
if you brush up with your SQL. you can easily achieve what you want.
Andrej Vckovski wrote in message ...
>Hi,
>
>I was wondering if anyone as experience what HW requirements there
>would be for an Oracle 8 to support inserts and updates in a order of
>magnitude of about 200 single-row updates/inserts per second in a
>table of about 30'000 rows. The data is not as critical (no archive
>log etc. necessary). Is this achievable with Oracle or do we need to
>use a main-memory database for that?
>
>TIA for any hints,
>
>- Andrej.
>
>---------------------------------------------------------------------------
-
>Andrej Vckovski, Netcetera AG, CH-8040 Zuerich
andrej.vckovski_at_netcetera.ch
>Phone: +41 (1) 247 79 05 Fax: +41 (1) 247 70 75
http://www.netcetera.ch
>
Received on Thu Mar 25 1999 - 00:08:05 CET