Re: web counter with oracle

From: Valery Yourinsky <vsu_at_softexpress.ru>
Date: Thu, 17 Jun 1999 15:39:37 +0300
Message-ID: <3768ddf6@mail.softservice.ru>

Kumar, Sai (EXCHANGE:PERPK:3374) <saikumar_at_nortel.com> wrote in message news:376673E4.B5D19684_at_nortel.com...
>mgoode_at_bellsouth.net wrote:
>
>> trying to build a web counter and am concerned with oracle handling
>> thousand of updates per second. Does any one have experience they would
>> be willing to share regarding oracle and realtime web udpadtes. replies
>> would be greatly appreciated
>
>Lock the table that is holding the counter info. in share mode, that
>way the table is locked based on a first cum first serve basis
>updated and the lock is released for the next user to use it.
>I use this concept in one of my application and works fine.

You also can base your counter on SEQUENCE... This is a way to avoid concurrent updates

Valery Yourinsky
---
Softservice, Moscow
ORACLE PARTNER
tel/fax (095) 333-63-10, 128-18-21
http://www.softexpress.ru
ICQ# 368 97 94
second E-mail: vsur_at_usa.net Received on Thu Jun 17 1999 - 07:39:37 CDT