Opinion requested

Wondering if someone has this situation before?

What will be the best way to serve up a simple html page containing at most 50 lines from the Oracle8i server.

The requirements are:

-Client will connect using HTTP (it is not a browser).

-The client will always request the same page with different
parameters passed as query string in the url. Like this - http://server.domain.com/whatever.here?p1=x&p2=y&p3=....

-The page served itself is simple (atmost 50 lines of text)

-The logic to generate page is very complex and requires lot
of database lookups and recording.

-The number of clients would be in millions logging upto
40 hits/second at peak times.

What in your view is best architecture/tools for this type of scenario.

I was thinking of implementing lookup logic using Java inside Oracle itself. However I have yet to find out how to call that Java code in the best possible way - Servlets? JDBC? perl?

I will appreciate your opinions.

I have experience with ASP, Perl, CFML and little bit JAVA on web server side. and Transact SQL(M$) and PL/SQL on the database side.

Currently I have the solution implemented using IIS/ASP and SQL Server 6.5 and it has started to crash at times (IIS and not SQL Server crashes) though we have not achieved the full load, as described above, yet.

Thanks in advance...

1. Raman also pls email me directly araman_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 15:53:44 CEST