| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: MTS for 5,000 All-at-Once Users
> 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
> think the Elementary database will be hit pretty hard. The second big hit
> will be the hourly attendance uploaded from High Schools and Middle
> Schools, but that's fewer teachers and it's spread across two
> databases/servers.
Not to get slightly off-topic here, but this sounds like the perfect use of HTML DB. Create a custom form for them to login to the web, then either enter the information directly into a form, or just allow them to use the upload feature. Then you have all the data right there. No performance issues, easy collection and maintenance of the application, and about as thin a client as you can get. Get a decent box (hardware) and you shouldn't have any problem with 5,000 users connecting.
Like Jared, I think it sounds like a fun application! ;-)
thanks,
bruce
-- 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 Sun May 16 2004 - 10:49:42 CDT
 |
 |