Performance question: OAS, WebDB...

From: Kim Johnsson <kim.johnsson_at_elementum.fi>
Date: 2000/04/24
Message-ID: <8e17e8$8t2$1_at_tron.sci.fi>#1/1


We will be building a web-based database system to replace an existing one which currently has an average of 22 requests per second, and peaks to 300 requests per second. The system is/will be a tool for university students for getting information about courses, happenings etc as well as managing their own personal calendars and signing up for courses and so on. Nothing terribly complex, but the current solution simply can't handle the traffic, which is the problem we are trying to solve. The traffic will become heavier over time.

We will most likely be using an Oracle 8i database. For the rest of the architecture we have considered the following setup alternatives:

  1. OAS with WebDB 2.2 (as 3.0 doesn't seem to be available yet), or
  2. Some web server providing static HTML documents containing Java applets connecting to the database over OAS Java Enterprise Beans

The user interface functionality is not as important as the overall reliability of the system.

I would like to hear about your experiences with systems like the one described above. What would you think would be an optimal configuration for our problem (number of web servers, OAS's, WebDB's, how are they spread over multiple computers and so on)? What are the specific issues we should look into?

Any hints greatly appreciated.

Thanks,

        Kim Johnsson Received on Mon Apr 24 2000 - 00:00:00 CEST

Original text of this message