Re: Help with oracle performance (alpha)

Dilip Dasilva wrote:
>
> We are developing a simple application that needs to handle hundreds
> of transactions/sec. Each transaction contains four items.
> The buyer, the seller, the object bought and the price.
>
> Currently we have implemented the app using an oracle 7.3
> on a dec 4100 (4 processor).
> Each transaction is entered into a big table of transactions.
> We have three indexes on the table - on the buyer, the
> seller, and on the object bought. This is so we have queries
> like "list all the objects sold by a seller". Currently,
> each insertion of a transaction takes
> 3 ms. But each index on the table causes the insertion time
> to increase by 3 ms. So with the three indexes on the table,
> the total time for each insertion is 12 ms. This gives
> us about 80 transactions/sec. We need to get much higher
> performance than this. We have also tried multi-threading
> the application but this does not increase the through-put
> of the insertions.
>
> Does anyone have any idea about how to increase performance -
> or have we reached the limit of oracle.
>
> Thanks, Dilip

This may be too simplistic, but here goes:

Remove the indexes on the transaction table. Create a Snapshot of the transaction table to use for queries and then index the Snapshot.

Wes Received on Fri Dec 13 1996 - 00:00:00 CST