Re: Netscape LiveWire or ORACLE web server, Which works better ?

In article <slrn5efeu0.jai.victorlu_at_centromere.basefour.com>, victorlu_at_adenine.basefour.com says...
>
> Netscape LiveWire or ORACLE web server
>
> Web server : More direct case tools from ORACLE ?
>
> Netscape LiveWire: No need to run another server (ORACLE web server)
> and speed faster ???
>
> Any information on this ?
>
> I prefer Oracle web server, but other developers in my group
> prefer LiveWire, please shed some lights on this issue !
>
> Thank you !
>
> Victor

For what it's worth...

I currently am the DBA for several databases were I work (First Data Corp) my main database (Oracle 7.3.2.2 AIX 4.1.4) is being accessed by a webserver (NT 3.5.1) using livewire.
We have been very successful developing this project but there are several major bugs with livewire/enterprise manager (vers 2.01). First of all livewire does not handle it's connections to the database very well. Our experience is that if you get more simulatanous (sp) users on the webserver than the max number of database connections defined for the application it (the app) will hang. Setting the number of connections at 0 is supposed to let it get as many connections as it wants but that doesn't work either. Something else interesting is that the maximium number of connections you define is established as soon as you start the application. To get around this I have set up Multi-Threading for the database connections and specified 150 connections in livewire. Thus far this has worked very well.
Another issue with enterprise manager is that the application will sometimes hang for no apparent reason. This is a known problem with version 2.0 and 2.01 is supposed to fix (but apparently hasn't). If you want to really find out more I would suggest getting on the news groups for livewire. On the other hand one of my associates set up Oracle Webserver. He told me that it only supports SQL Net 1 (I don't know how true that is but that can certainly be an issue). The webserver also seemed to be a resource hog as well. Please keep in mind that the Oracle Webserver info I have is second hand. and even though we have had problems with livewire we have been successful using it. (whew didn't mean to be that long winded)

hope that helps

Carl Christianson Received on Sat Jan 25 1997 - 00:00:00 CST