Re: Opinion requested
From: Josue Batista <jbatista_at_abcsolutions.org>
Date: 1999/07/10
Message-ID: <7m8r5e$d6o$1_at_nntp5.atl.mindspring.net>#1/1
Date: 1999/07/10
Message-ID: <7m8r5e$d6o$1_at_nntp5.atl.mindspring.net>#1/1
Hi, you might want to consider Java server-side servlets to manage the HTML request, access the Oracle database to run the apropriate business logic, and send back just plain HTML responses. Check out our web site for examples of that architecture. We are running Oracle for Linux, Apache web server (very safe, no crashes) and Java.
If you are not in a hurry, I am willing to hear more about your project and maybe get involved in the development if there is a promissing marketing and business opportunity.
Hope that helps.
-- Josue Batista ABC Tech Solutions http://www.abcsolutions.org [Java/Oracle/Linux] [C/S & Internet Database Apps] araman_at_my-deja.com wrote in message <7m4ut3$ar2$1_at_nnrp1.deja.com>...Received on Sat Jul 10 1999 - 00:00:00 CEST
>Hi,
>
>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...
>
>A. 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.