Re: 1000 connections to Oracle or 1000 connections to messaging server?

Cliff Court wrote:
>
> I have a situation which calls for a choice between having 1000 concurrent
> users connecting directly to an Oracle server (with its associated high cost
> of licencing) or to allow the 1000 users to send a message to a message server
> (eg Microsoft Exchange server 5). The messaging server would then pull the
> requests off the queue and send them through to the Oracle server. The benefit
> is far lower cost and the ability to add prioritisation to each message. My
> concern is whether one (or more) such messaging boxes (eg NT boxes) could feed
> the Oracle box fast enough.
>
> Is there anyone out there with experience in these matters? I know there is no
> one answer, but I'm looking for guidelines.
>
> Thanks
> Cliff Court

If you take the latter alternative (through message server) you may have difficulty in concurrency issues. Say for instance if two users try to update the same row, both updates will go through since Oracle will see them as single user, whereas the expected behaviour is that the second user should wait until the first user commits. Received on Tue Aug 26 1997 - 00:00:00 CDT