Re: Q? Web Forms Performance

We just fired up our first Oracle Web application and other than the initial 8 to 15-ish seconds to get to the login (JInitiator driven) it is actually quite unbelievable how great the performance is. I don't see any difference in query, insert, update time compared to our client/server version running in a window along side. So, it is not the tool. rq

sensslen_at_gds.ca wrote:

> Hi Everyone,
>
> I'm an Oracle Developer and an Internet developer. I wear two different
> hats. I build Client server applications using oracle's developer toolset
> and I build internet applications using other toolsets (sybase,IBM,
> microsoft,etc).
>
> In January, I put together a demo of Oracle forms server web
> deployment. I ported 5 forms from forms 4.5 to 5.0 and set up the forms
> server.
>
> Performance was awful. It was not unusual to have to wait 60
> seconds for the first form to open or a noticeable amount of time to
> insert records, etc. We were able to start the "thin" applet, the go to
> our desktops, start the client server version of forms, and enter and
> commit a record in the client server version before the applet window
> even appeared.
>
> Some quantifiable information was the the forms server process took
> up to 8-9 MB RAM per connection server side and at time in excess of 5
> MB client side. It took so long to download between two machines on the
> same 10baseT ethernet LAN that we never considered running it over the
> internet ( minute at 10 Megabit = 20 minutes at 50K bit? Who's going to
> wait for that?)
>
> Is this normal? Does anyone have any ideas on how to improve this? I've
> tried contacting Oracle but they're stone walling me (which leads me to
> believe that this is normal and that the product really is awful). Any
> replies of your experiences would be appreciated.
>
> Steven Ensslen
> sensslen_at_gds.ca
> GDS & Associates Ltd.
> (Yes, we are Alliance members. Yes, I've checked all the sites).
>
> Ok. Stats on what we're running:
>
> Database/Application/Web Server:
> P200, 64 Meg RAM, NT4 sp3.
> Database: Oracle 7.3.2.1.1 work group
> Forms Server from developer 2.1 CD
> Web Server : IIS 4
> (Other things running on server: 2 instances with maybe 5
> connections, also used as file server by 5 people(total not concurrent))
>
> Network: 10 Base T (10 Megabit ethernet), 1 hub between server and
> client
>
> Clients: P166/P200, 96MB RAM, NT4 sp3 workstations
> Browsers: IE 3+, NN3+
> (notably, Forms server doesn't work with IE3
> or NN3, despite the repeated claims of supporting all browsers.
> JInitiator is a hack. If Oracle supported the browsers they wouldn't
> need plugins).
>
> Other things running on client - Nothing, We shut everything else
> off.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Feb 19 1999 - 16:26:27 CET