[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

2921.0. "Lotus GOLD K Performance problem" by KERNEL::SALMONJ (Jason Salmon) Fri Jun 25 1993 15:26

Hello,

Quitting (GOLD K or /Q) from Lotus 1-2-3 in ALL-IN-1 is very CPU hungry. I have 
an 1800 block example spreadsheet which takes approx 5 minutes CPU time to quit  
out of. To quit from exactly the same spreadsheet using the VMS version takes 
less than 1s CPU! Obviously a significant difference in user perception of 
performance.

This is probably a Lotus issue but I ask the question here because it uses 
INSTAL/EXECUTE which may have a bearing on this.

Versions: ALL-IN-1 V3.0-1, Lotus V1.5 for ALL-IN-1 and VMS, VMS 5.4-3
The problem has also been noted using Lotus V1.0 and V1.5 on ALL-IN-1 V2.4.

Attached below are the results of a show  process before and after these 
operations on both ALL-IN-1 and VMS.

Could anybody suggest what might be causing this?

Thanks
Jason

1.1 Before Quitting within ALL-IN-1
   Gold K

                             Process Jason 1                    10:38:22



    State               LEF                 Working set             2048

    Cur/base priority   4/4                 Virtual pages          33988

    Current PC          7FFEE07A            CPU time     000:00:19:24.36

    Current PSL         03C00000            Direct I/O              4006

    Current user SP     7FE7EF88            Buffered I/O           21733

    PID                 23C00709            Page faults          3457986

    UIC                 [SALMON]            Event flags         E1000001
                                                                C4000000


    WAYOUT$DUA31:[ALLIN1.LIB_SHARE]OA$MAIN.EXE

1.2 Quit above finished


                             Process Jason 1                    10:46:05



    State               LEF                 Working set             2048

    Cur/base priority   7/4                 Virtual pages          33988

    Current PC          7FFEE07A            CPU time     000:00:24:04.98

    Current PSL         03C00000            Direct I/O              4009

    Current user SP     7FE81E3C            Buffered I/O           21772

    PID                 23C00709            Page faults          4523477

    UIC                 [SALMON]            Event flags         E1000001
                                                                4C000000

2.1 Before saving same spreadsheet using GOLD F

                             Process Jason 1                    10:47:54



    State               LEF                 Working set             2048

    Cur/base priority   4/4                 Virtual pages          33988

    Current PC          7FFEE07A            CPU time     000:00:24:24.59

    Current PSL         03C00000            Direct I/O              4340

    Current user SP     7FE7EF88            Buffered I/O           21819

    PID                 23C00709            Page faults          4537685

    UIC                 [SALMON]            Event flags         E1000001
                                                                C4000000


    WAYOUT$DUA31:[ALLIN1.LIB_SHARE]OA$MAIN.EXE


2.2 After saving above.

                             Process Jason 1                    10:56:56



    State               LEF                 Working set             2048

    Cur/base priority   7/4                 Virtual pages          34116

    Current PC          7FFEE07A            CPU time     000:00:29:06.02

    Current PSL         03C00000            Direct I/O              4989

    Current user SP     7FE81E3C            Buffered I/O           21991

    PID                 23C00709            Page faults          5468239

    UIC                 [SALMON]            Event flags         E1000001
                                                                4C000000


3.1 Before quitting on VMS version

   
                             Process Jason 1                    10:59:46



    State               LEF                 Working set             2048

    Cur/base priority   6/4                 Virtual pages          10948

    Current PC          7FFEE07A            CPU time     000:00:29:28.62

    Current PSL         03C00000            Direct I/O              5408

    Current user SP     7FE8411C            Buffered I/O           22213

    PID                 23C00709            Page faults          5482892

    UIC                 [SALMON]            Event flags         E1000001
                                                                4C000000


    WAYOUT$DUA30:[SYS0.SYSCOMMON.][SYSEXE]LOTUS123$MAIN.EXE;3
   

3.2 After quitting VMS version 


                             Process Jason 1                    11:00:15



    State               LEF                 Working set              260

    Cur/base priority   4/4                 Virtual pages           3038

    Current PC          8057984C            CPU time     000:00:29:29.19

    Current PSL         02800000            Direct I/O              5409

    Current user SP     7FE83EE0            Buffered I/O           22251

    PID                 23C00709            Page faults          5483571

    UIC                 [SALMON]            Event flags         C1000001
                                                                4C000000

3.1 Before quitting on VMS version

   
                             Process Jason 1                    10:59:46



    State               LEF                 Working set             2048

    Cur/base priority   6/4                 Virtual pages          10948

    Current PC          7FFEE07A            CPU time     000:00:29:28.62

    Current PSL         03C00000            Direct I/O              5408

    Current user SP     7FE8411C            Buffered I/O           22213

    PID                 23C00709            Page faults          5482892

    UIC                 [SALMON]            Event flags         E1000001
                                                                4C000000


    WAYOUT$DUA30:[SYS0.SYSCOMMON.][SYSEXE]LOTUS123$MAIN.EXE;3
   

3.2 After quitting VMS version 


                             Process Jason 1                    11:00:15



    State               LEF                 Working set              260

    Cur/base priority   4/4                 Virtual pages           3038

    Current PC          8057984C            CPU time     000:00:29:29.19

    Current PSL         02800000            Direct I/O              5409

    Current user SP     7FE83EE0            Buffered I/O           22251

    PID                 23C00709            Page faults          5483571

    UIC                 [SALMON]            Event flags         C1000001
                                                                4C000000
T.RTitleUserPersonal
Name
DateLines
2921.1Lots of page faultsIOSG::NEWLANDRichard Newland, IOSG, REO2-G/L2Fri Jun 25 1993 20:0011
The SHOW PROCESS information shows that there are a huge number of page 
faults (approx 1 million) during the long delay.  I suggest you do the 
following to isolate what is causing the page faults:

    1.	Just before doing a GOLD-K or GOLD-F turn on the ALL-IN-1 debugger.

    2.	Step through each ALL-IN-1 function and monitor using SHOW PROCESS
    	which take a long time to execute and/or generate many page faults. 


Richard
2921.2WAYOUT::TALBOTTrevor TalbotTue Jul 06 1993 15:277
Hi Richard,

	Thanks for your advice here, however, after 
checking into the problem further it looks likely to be 
a coding problem inside the Lotus 123 image file. 

-Trev