Re: Oracle 9ias and Forms..

First of thanks very much for answering the question on Oracle 9ias and forms in Google User Group. I am struck with something, your help would be of great help to me.

1. What are the configurations i have to address in Oracle 9ias server (forms90.properties) to work effeciently. If you could paste your existing configurations it would be of great help.
2. Do i have to address any parameters in formsweb.cfg (any config settings)??
3. Is that any property that i have to address in JINITATOR (any config settings)??

any help would be of great help

Rgds

"Luc Gyselinck" <Luc.Gyselinck_at_nospampandora.be> wrote in message news:<ovHqb.8151$TE2.358426_at_phobos.telenet-ops.be>...
> Was your Forms 6 application already deployed for the Web ?
>
> WebForms have 3 components: the client (applet), the application server (the
> ifweb process) and the database (Oracle) (opposed to the client/server setup
> which has only 2 components):
> The first component takes care ONLY for the presentation!
> The second handles the data retrieval and data manipulation and executes the
> triggers in the forms.
> The third ... manages the data.
>
> So, whenever the user manipulates the presentation layer, ie presses a key,
> clicks the mouse buttons, moves the windows,... the applet generates an
> event that is passed to the ifweb process, which sends back instructions of
> what should be changed on the screen: one network roundtrip for each event.
>
> For your example, navigating to another field with the tab key, involves :
> sending the 'tab key pressed' message to the server, the ifweb process
> executes the WHEN-VALIDATE-ITEM trigger, the POST-TEXT-ITEM trigger, the
> PRE-TEXT-ITEM trigger (and others), and sends instructions back to the
> applet: show a warning (validation failed) or 'move the cursor' or change
> the properties of a field or ...
>
> If this takes a long time, either:
> - your network is slow
> - your proxy server is slow (if using a proxy server)
> - your web server (Apache ?) is slow
> - your DNS server is slow : your web server logs names in stead of ip
> adresses
> - the forms trigger code takes a long time to execute (queries are slow)
> - the database connection (Net8) between ifweb and database is slow
>
> Luc
>
> "Vijays" <srinivasanvijay_2000_at_yahoo.com> wrote in message
> news:fe3d44d1.0311062110.2b5ce3fb_at_posting.google.com...
> > Hello All,
> >
> > We have converted the Forms 6 to Oracle 9ias Webforms. We did some
> > amount of tuning as per the guidelines i.e. removed form level
> > triggers, block level triggers, field level validation Etc...
> >
> > Now when the forms is getting loaded (no form level triggers) it is
> > taking lot of time on ABOVE THAT the real strange thing is the
> > navigation between each field is taking lot of time i.e. Tab out from
> > col1 to col2 it takes lot of time.
> >
> > Any help is really appreciated..
> >
> > Vj..
Received on Mon Nov 17 2003 - 04:52:51 CST