Speed of Portal

[Francois Calvert]

Hello,

I have a DB2 Schema that has 1,200 tables. When we do the profiling it is slow do get the data back.

Any solution?

Thanks

Francois

[Scott Schmitz]

Hi Francois,

Are you specifying Basic or Advanced scan level?   Basic will be faster as it only looks for key relationships rather than data relationships.
And what is your definition of slow?   How long does it take?

Scott

[Francois Calvert]

I'm talking in the portal when you go in Data Model and see all of the table to go and select the TAG. It's slow when you try to see all of the table and it's slow when you go in a tile to get the button to show.
Thanks
Francois

[Scott Schmitz]

Ok, thanks for clarifying.   Working with 1,200 tables can take a bit for Portal to process.   As you mentioned tags, I believe your concern is on the PII audit results (heatmap) display.    Portal has multiple ways to filter the number of tables to a more reasonable number (and will make the responses faster).   Consider:

(1) Using the "Risk" slider to reduce the number of tables displayed (eliminating very low risk / Not PII in the example below) 

(2) Otherwise, if you know what table(s) you wish to work with, filter using the field entry:

If this was not the area of the Data Model you were concerned with, please let me know.

[Francois Calvert]

I would like the HEATMAP to be faster but I know that 1,200 tables can take some times. 

I'm more concern with the time it takes to have the button available when you select a Table (tile), It can take up to 30 sec to 1 minutes before we can access the option to add or remove some tags.

Thanks

Francois

[Scott Schmitz]

Could you try filtering at the heatmap level first, then select the tile?   I'm vaguely remembering that the filtering improved overall performance in an engagement when processing 2000+ tables.

[Francois Calvert]

Hello,

It does not help.

Thanks

Francois

[Scott Schmitz]

What version of the portal are you on?   (Click the "about" link bottom left of the Portal Window).   Am asking as I just did a test with a 1300 table schema.   In TDM v4.7 it was 41 seconds to display the tags, but with TDM v4.8.1 (latest patch 4.8.124.0) it took about 4 seconds (on a somewhat faster system).