1 2 Previous Next 18 Replies Latest reply: Apr 16, 2012 3:54 AM by user11170803 RSS

    Forms takes so much time in opening.

    Zafar Iqbal
      Hi,

      the forms that are configured for web utility that takes so much time in opening. I have done so much RND but could not find the reason. I have change the browser IE6, and Mizilla Firefox and JInitiator to Java Run Time(JRE) but the behaviour is same.

      Regards,


      Zafar
        • 1. Re: Forms takes so much time in opening.
          spilgrim
          What is RND ?

          Are you saying it's slow to load a Form in the runtime environment ?

          What if you run them locally ?

          Which version of Forms are we talking about and which operating system and where is the database you're connecting to ?
          • 2. Re: Forms takes so much time in opening.
            CraigB
            the forms that are configured for web utility that takes so much time in opening.
            What do you mean by *"for web utility"?* Is your Forms application web deployed?

            Remember, it is always better to give too much information than not enough. It is best to always list your Forms version, OS version and, if web deployed, your Browser and Java versions.
            I have change the browser IE6, and Mizilla Firefox and JInitiator to Java Run Time(JRE) but the behaviour is same.
            This statement suggests your application is web deployed, but I don't want to assume this is the case.

            Please explain the issue in more detail and give us more information about your configuration.

            Craig...
            • 3. Re: Forms takes so much time in opening.
              Zafar Iqbal
              I mean to say "Research and Development"
              brain storming... :-)

              yes slow to load a form in runtime environment :-)

              on some machines forms does not take so much time load in runtime environment quickly.

              Version
              =================
              Forms Version 10.1.2.0.2

              Operating System
              =================
              On Client Side := Microsoft Windows Xp
              On Server Side := Microsoft Windows Server 2003

              Java Runtime
              =================
              Oracle JInitiator: Version 1.3.1.22
              &
              JRE (build 1.6.0_24-b07) (Same behaviour on Both runtimes)

              Database
              =================
              Database is placed in the same network (LAN)
              • 4. Re: Forms takes so much time in opening.
                Zafar Iqbal
                Hi Craig,

                thanks for replying me.

                *"For Web Utility"* I mean to say "webutil"

                Forms Version
                =================
                Forms Version 10.1.2.0.2

                Operating System
                =================
                On Client Side := Microsoft Windows Xp
                On Server Side := Microsoft Windows Server 2003

                Java Runtime
                =================
                Oracle JInitiator: Version 1.3.1.22
                &
                JRE (build 1.6.0_24-b07) (Same behaviour on Both runtimes)

                Database
                =================
                Database is placed in the same network (LAN)
                • 5. Re: Forms takes so much time in opening.
                  spilgrim
                  I can't think of a reason for that : what does the java console say ? (is there a big pause somewhere when loading)

                  Are you able to monitor your network connection so see what is being send and received ?

                  What is the time difference anyway ? 1 minute ? 10 seconds ?
                  • 6. Re: Forms takes so much time in opening.
                    Christian Erlinger
                    Did you take a look at where the time is spent by e.g. writing down systimestamps before and after actions? Also this
                    the forms that are configured for web utility that takes so much time in opening
                    is a very unspecific description. As you might well be aware webutil contains a lot of functions. I don't suspect you use every single one of them in your form.
                    So first of all find out where the time is actually spent by putting trace messages in your form and compare the timestamps, and then show us the code which takes long.

                    cheers
                    • 7. Re: Forms takes so much time in opening.
                      InoL
                      If have also noticed before (with completely different versions though) that an invalid PATH variable slows down the startup. Check if one of the PATH variables (FORMS, REPORTS etc.) includes an invalid directory.
                      • 8. Re: Forms takes so much time in opening.
                        Zafar Iqbal
                        Java console say nothing it remain normal
                        but there is round about 1 minute pause approximately
                        • 9. Re: Forms takes so much time in opening.
                          Christian Erlinger
                          Again: did you measure where the time is spent? What webutil functions do you call at startup? Right now there is not much to work with as the only thing we know for sure is "it is slow". Please investigate where the time is spent, and come back with this information. Otherwise we'll have to permanently guess what the problem might be which will take additional time to get you the solution.

                          cheers
                          • 10. Re: Forms takes so much time in opening.
                            Zafar Iqbal
                            form is taking time in loading. when form is loaded than it works fine
                            • 11. Re: Forms takes so much time in opening.
                              Manu.
                              Zafar,

                              Is there lots of Combo boxes are there in your form? If yes, then try changing them to Text Item and LOV.

                              And also check your codes in the triggers which are firing at form startup.


                              Regards,


                              Manu.

                              Edited by: Manu. on Mar 26, 2012 10:33 AM
                              • 12. Re: Forms takes so much time in opening.
                                ahmad
                                same problem with me...
                                when i run the application from my laptop its tooooo slow but its normal in other Pcs.
                                I dont know why ?
                                • 13. Re: Forms takes so much time in opening.
                                  Zafar Iqbal
                                  absolutely right
                                  I am facing this kind of problems it happened only on different systems not all.
                                  • 14. Re: Forms takes so much time in opening.
                                    Zafar Iqbal
                                    Manu

                                    thanks for your reply

                                    my form is so much simple it is based on only one table there is no any combo box on it.

                                    WHEN-NEW-FORM-INSTANCE trigger has not much code i have checked it it is running smoothly on SQL Plus and toad as well.
                                    1 2 Previous Next