It is so slooooow to have a FORM calls a report

It is so slooooow to have a FORM calls a report

Post by Jo » Fri, 12 Jul 1996 04:00:00



Hi,

  I am running a FORM(v45) calls a report through RUN_PRODUCT.
  It takes soooooo long to bring up the report.   I am runing this form
  on AIX 4.1.2.
  Is it always so slow or am I doing something wrong?

Thank you for all infos.

 
 
 

It is so slooooow to have a FORM calls a report

Post by Robert Monic » Sun, 14 Jul 1996 04:00:00



Quote:

>  I am running a FORM(v45) calls a report through RUN_PRODUCT.
>  It takes soooooo long to bring up the report.   I am runing this form
>  on AIX 4.1.2.
>  Is it always so slow or am I doing something wrong?

Our experience on Windows client is that it is about what
you would expect.  The Oracle Windows apps are BIG, so
32 MB of memory really speeds things up.  At 16 MB, we
get a lot of disk swapping activity.

Hope this helps.

 
 
 

It is so slooooow to have a FORM calls a report

Post by p.. » Mon, 15 Jul 1996 04:00:00



>  Hi,

>    I am running a FORM(v45) calls a report through RUN_PRODUCT.
>    It takes soooooo long to bring up the report.   I am runing this form
>    on AIX 4.1.2.
>    Is it always so slow or am I doing something wrong?

>  Thank you for all infos.

I suffered from the same performance problem in calling a report from a from.  Actually Oracle have to
load a "Report Server" at background first before loading the report.  You may try to load the report server
 first just when you enter Windows.  It helps a little bit.  But if your report is large enough, you still have to
wait a looooooooong time.

P.S.

~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~ ~~~~~~~~~
 ~~ Life is always Hard ~~~~~~~~~ ~~~~~~ ~~~~~ ??q??P ~~~~~~ ~~~~~~~
  ~~~ Love is never Smooth ~~ ~~~~~~~~~~~~~ ~~~~ R??D?Z3~ ~~~~~~~~~~~~~~
   ~~~~ Always Love hard and never Life smooth ~~~ ?|3??|aR,?y?Ro?a? ~
    ~~~~~~~~ ~~~~~ ~~~ ~~~~~~~~~~~~~~~ ~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~~
~~~~~~~~
     ~~~~ ~~~~~~~~~~~~~~~~~~~~~ ~~ ~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~ ~~~ P.S. ~~~~~
                                                      ~~~~ ~~~~~~~~~~ ~~~~~~

 
 
 

It is so slooooow to have a FORM calls a report

Post by DB » Tue, 16 Jul 1996 04:00:00


:   I am running a FORM(v45) calls a report through RUN_PRODUCT.
:   It takes soooooo long to bring up the report.   I am runing this form
:   on AIX 4.1.2.
:   Is it always so slow or am I doing something wrong?

    Try to execute CDEInit.exe for better performance on loading.

    Should you have any enquiries, please feel free to email to me.

--
                                                               Best Regards,
                                                                 Lun Wing San


Telephone     : (852)2758 5936 / (852)2788 5841                          

 
 
 

It is so slooooow to have a FORM calls a report

Post by Diamond Joe Shmeng » Wed, 17 Jul 1996 04:00:00


I was talking with Oracle help one day, and told them I couldn't stand
how long it takes to load forms.  They referenced CDEINIT and also
referred me to this file.

Excerpt from C:\ORAWIN\REPORT25\DOC\RELNOTES.WRI
(Copied w/o permission.)

5.8     'CDE Init' Utility

        In response to numerous requests from our DEVELOPER/2000 customers,
        we have provided a new utility called 'CDE Init' on MS Windows
        which allows you to load in advance a set of common code shared
        by all of the DEVELOPER/2000 tools.

        This leverages the large amount of common code among the
        DEVELOPER/2000 tools and has the effect of making any of the
        DEVELOPER/2000 tools load more quickly, especially after repeated
        startup and shutdown.

        If desired, you can configure your users' environment such that 'CDE
        Init' is run at Windows startup.  Your users can then reap the
        benefits of this advance load each and every time they invoke an
        application developed with DEVELOPER/2000 tools.

        To run 'CDE Init' at MS Windows startup you can create an icon in the

        "Startup" group.  This icon would have a command line choosen from
        the selection below to achieve the desired result.  The CDEINIT.EXE
        executable in the Oracle Home directory has several options.
        Presuming the ORACLE_HOME is set to the default of "C:\ORAWIN",
        then the available command line options for 'CDE Init' are:

        C:\ORAWIN\BIN\CDEINIT          (the default)

        C:\ORAWIN\BIN\CDEINIT FORMS    (default + preload Forms Runtime )

        C:\ORAWIN\BIN\CDEINIT GRAPHICS (default + preload Graphics Batch)

        C:\ORAWIN\BIN\CDEINIT UNLOAD   (unload all loaded code)

        C:\ORAWIN\BIN\CDEINIT SHOW     (shows dialog with statistics)

        When used with Reports, use the 'CDEINIT' command, or use the Reports
        Server executable.  The first will pre-load all needed DLL's for all
        executables, the latter will do the same and load the Reports Server.
        If you decide to use both, the first will load the initial DLL's
        needed, and the Reports Server will just load the Server executable.

        Note that the Designer DEVELOPER/2000 Tools also share this common
        code, so the comments above can be leverages for starting up the
        design tools as well. This applies to the Reports Server as well.

        We do not recommend CDE init for Win-OS/2 environments.  We also
        recommend that you run the CDE Init utility with the UNLOAD option
        before running the Oracle Installer.

End Excerpt.

Now that I'm working in NT full time, I don't use it at all, though.
I think the OS/2 note also applies to NT.

Before developing in NT, I didn't like the extra memory consumption
while I wasn't working in Forms.  Loading/Unloading by hand seemed
more time consuming than waiting for Forms to start up.



>>  Hi,

>>    I am running a FORM(v45) calls a report through RUN_PRODUCT.
>>    It takes soooooo long to bring up the report.   I am runing this form
>>    on AIX 4.1.2.
>>    Is it always so slow or am I doing something wrong?

>>  Thank you for all infos.

>I suffered from the same performance problem in calling a report from a from.  Actually Oracle have to
>load a "Report Server" at background first before loading the report.  You may try to load the report server
> first just when you enter Windows.  It helps a little bit.  But if your report is large enough, you still have to
>wait a looooooooong time.
>P.S.
>~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~ ~~~~~~~~~
> ~~ Life is always Hard ~~~~~~~~~ ~~~~~~ ~~~~~ ??q??P ~~~~~~ ~~~~~~~
>  ~~~ Love is never Smooth ~~ ~~~~~~~~~~~~~ ~~~~ R??D?Z3~ ~~~~~~~~~~~~~~
>   ~~~~ Always Love hard and never Life smooth ~~~ ?|3??|aR,?y?Ro?a? ~
>    ~~~~~~~~ ~~~~~ ~~~ ~~~~~~~~~~~~~~~ ~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~~
>~~~~~~~~
>     ~~~~ ~~~~~~~~~~~~~~~~~~~~~ ~~ ~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~ ~~~ P.S. ~~~~~
>                                                      ~~~~ ~~~~~~~~~~ ~~~~~~

 
 
 

1. "HAVING" problems with query and using 'having' with group by

Try this:

select max(note.datetime),

acgr.group_code,

bank.local_acc_no,

bank.short_name,

DECODE

(bank.account_type,

,'Nostro',

1,'Internal',

2,'Safe Keeping',

3,'Draft',

4,'Vostro',

5,'Suspense',

6,'Exchange',

7,'Netting',

8,'Mutual Funds',

'UNKNOWN') AS "Acc Type",

item.gin,

item.value_date,

item.entry_date,

item.ls_type AS "LS Type",

item.currency AS "Currency",

item.amount AS "Amount",

item.sfield_7 AS "SField 7",

item.sfield_8 AS "SField 8",

item.sfield_9 AS "SField 9",

item.bran_code,

note.notetext

FROM

grup,

acgr,

bank,

item,

note

WHERE grup.group_code = acgr.group_code

AND acgr.corr_acc_no = bank.corr_acc_no

AND bank.corr_acc_no = item.corr_acc_no

AND item.corr_acc_no = note.corr_acc_no

AND item.gin = note.gin

AND item.flag_2 = 0

AND grup.group_code = 'GMSAZSGREC99'

and bank.account_type in (0)

group by

acgr.group_code,

bank.local_acc_no,

bank.short_name,

DECODE

(bank.account_type,

,'Nostro',

1,'Internal',

2,'Safe Keeping',

3,'Draft',

4,'Vostro',

5,'Suspense',

6,'Exchange',

7,'Netting',

8,'Mutual Funds',

'UNKNOWN') AS "Acc Type",

item.gin,

item.value_date,

item.entry_date,

item.ls_type,

item.currency,

item.amount,

item.sfield_7,

item.sfield_8,

item.sfield_9,

item.bran_code,

note.notetext;

--
Posted via http://dbforums.com

2. Query wrt routing caches in DECnet Phase V on OVMS 7.1

3. How am supposed to know which init file I am using pfile or spfile?

4. New Site for Mac C++ framework "MacZoop"

5. Calling a form in a usrxit which is himself called by a a form..

6. Shiva NetModems

7. Q: How do I call report from forms 4.5

8. Toshiba Strata VI phone system

9. Help: Forms 4.0 -> Reports 2.0 call is SLOW

10. Error when calling Oracle Reports 2.0 from Oracle Forms 4.0

11. Forms 4.5/Reports 2.5-Can't run reports from forms

12. Converting Informix Forms/Reports to Oracle Forms/Reports

13. date problem in migrating Oracle Forms&Reports 4 to Oracle Forms&Reports 6