Re: MTS for 5,000 All-at-Once Users?
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 15 May 2004 18:34:24 -0700
On Sat, 2004-05-15 at 06:51, JApplewhite@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
