Immense slow startup of IFS10

Hi @filiep.vw 
 

I have been investigating the similar issue. Several issues were reported regarding the slowness when logging to the IFS application. 

This could be due to several reasons as well.

Reason 1 :
First check the following query.
SELECT COUNT(*) FROM IFS_IDP_CERTIFICATE_MGMT_TAB 

           This should return 1. In case there are more than one certificates, it might take some time to go through all the certificates.                  But for me, it wasn’t the case.

Reason 2:
Even for your case, this reason could be the relevant one.
In order to identify this please enable the debug at the beginning before entering the password.   

  

         Steps how to enable debug console before login

1. Hold the ‘SHIFT key’ while you click to open the IEE client.
2. Once you get this screen, ‘DOUBLE CLICK’ on the pop-up dialog, while holding the ‘SHIFT’ key, so ‘(debug console)’ will be displayed.
3. Then click ‘OK’ and login as normally you do.

Before you try this,

please make sure that the mode is ‘Framework’. If not make it ‘Framework’ And then exist. Then try to follow the same steps.
Go to tools -> options and check the visible rows in console and rows in console buffer to unlimited

 

Back to the problem...
 

With the output of the debug console, Notice 100+ FETCH command in the debug console, each of them with a duration of 50-150 ms

1)

select DISTINCT d.view_name

from dictionary_sys_view d

where d.view_name NOT IN (

SELECT ds.view_name

FROM dictionary_sys_view_column ds

WHERE ds.column_name = 'OBJID' )

2)

select vw.VIEW_NAME, vw.TYPE_OF_VIEW, vw.LU_NAME, lu.MODULE, lu.BASE_PACKAGE, language_sys.Translate_Lu_Prompt_(vw.LU_NAME) as TRANSLATED_PROMPT

from dictionary_sys_view vw inner join dictionary_sys_lu lu on vw.lu_name = lu.lu_name

where vw.VIEW_PROMPT IS NOT NULL ORDER BY VIEW_NAME

In each of these calls there will be subsequently 100+ fetch records each time. Since lot of records exist in these views it will result in hundreds of client-server requests during the login.

When this happens in a faster network, end user would not even notice. But when there is a network latency, it could aggravate the impact. It was only reported to some offshore offices only like Singapore, China etc. In your case you also experience this problem differently in China and Brazil, Thailand and Malaysia offices..

Improvements on the way...

Currently PD is working on this issue. PD will include the fix into a LCS Binary Patch, and some other dependencies if needed.  

This will be fixed very soon..

Hope this piece of information would be helpful for you..