Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Suitability for real-time data processing?

Suitability for real-time data processing?

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 1998/12/09
Message-ID: <KqSXWDA$Wwb2Iwj0@ahardy.demon.co.uk>#1/1

Hi,

I'm looking for a database for a 'real-time' (between 20ms and 1s responses) database for a inventory system.

We're tracking items in a warehouse and will require the ability to read and write around 20,000 items per hour and consult a 0.5 million row table of business rules for each read.

We will be using Compaq Proliant servers (clustered) and NT4.

I've narrowed down the choices to Oracle and SqlServer, but am unable to think of compelling reasons to choose between them. The corporate policy is towards SqlServer, but I'm a little wary of what appears to be relatively poor locking functionality (we'd have to use SqlServer 6.5).

So, why should I choose either database?

Andy

-- 
Andy Hardy
Received on Wed Dec 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US