Re: MTS for 5,000 All-at-Once Users?

From: Jared Still <jkstill_at_cybcon.com>
Date: Sat, 15 May 2004 18:34:24 -0700
Message-Id: <1084671263.15775.1968.camel@poirot>

On Sat, 2004-05-15 at 06:51, JApplewhite_at_austin.isd.tenet.edu wrote:
> This hadn't shown up in about 18 hours, so I'm resending it. Apologies if
> it's a duplicate.

Problems at freelists.org - fixed now.

...

> We are in the process of sizing servers for consolidating the 162
> far-flung dBase IV (go ahead and laugh, we have to - to keep from crying)

Actually, this sounds like fun to me.

> However, once each morning, all 5,000 Elementary teachers log on and
> upload their class attendance data. The data from each teacher is only
> the Student Numbers for 20 - 30 kids and the associated "Present" or
> "Absent" flags, perhaps with an Absence Code. It's not much, but
> multiplied by 5,000, all within probably a 10 - 15 minute span, and we
...

Jack, have you investigate Advanced Queuing for this? It sounds like it might be worth prototyping. If the data doesn't have to be there immediately, this could prevent killing your server even though they they all logon at once.

My guess would be that memory for all sessions in will be the least of your worries if they all hit 'COMMIT' in a short time period. :)

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat May 15 2004 - 20:25:16 CDT