Edit or clone view is very slow

Ederson Kamphorst shared this problem 10 months ago
Resolved

Hi folks,

I have a problem when I edit or clone the view. Those options are very slow and sometimes I got a mistake and I need to edit the view again, many times until I can change what I need and publish.


We use Yellowfin 7.4 with mysql on another server and our data warehouse is HPE Vertica. What can I do to log whats hapend with my ambient and solve the problem?


One example is a view, without reports who I edit and it loads about 20 minuts.

the SQL who this view have, returns 299.988 rows. very small.

this is the sql:

SELECT

"DIM_ITENS"."CLASSIFICAO_ABC",

"DIM_ITENS"."COD_DESCRICAO",

"DIM_ITENS"."COD_FAMILIA",

"DIM_ITENS"."COD_ITEM",

"DIM_ITENS"."COD_MARCA",

"DIM_ITENS"."COD_OBSOLETO",

"DIM_ITENS"."COD_TROCA",

"DIM_ITENS"."COD_VASILHAME",

"DIM_ITENS"."COD_VASILHAME_CAIXA",

"DIM_ITENS"."DATA_IMPLANTACAO",

"DIM_ITENS"."EMBALAGEM",

"DIM_ITENS"."FAMILIA",

"DIM_ITENS"."FT_CHAPA",

"DIM_ITENS"."FT_LITROS",

"DIM_ITENS"."FT_PALETE",

"DIM_ITENS"."GRUPO_ATIVO",

"DIM_ITENS"."ITEM",

"DIM_ITENS"."MARCA",

"DIM_ITENS"."MARCA_ANALISE",

"DIM_ITENS"."NOME_REDUZIDO",

"DIM_ITENS"."OBSOLETO",

"DIM_ITENS"."ORIGEM",

"DIM_ITENS"."QTD_VASILHAME",

"DIM_ITENS"."QTD_VASILHAME_CAIXA",

"DIM_ITENS"."RESERVA",

"DIM_ITENS"."SABOR",

"DIM_ITENS"."SABOR_TIPO",

"DIM_ITENS"."TIPO",

"DIM_ITENS"."UN",

"DIM_ITENS"."UNID_PT",

"FATO_ORCAMENTO_COMERCIAL"."FATURAMENTO_ORCADO",

"FATO_ORCAMENTO_COMERCIAL"."GERENTE",

"FATO_ORCAMENTO_COMERCIAL"."GERENTE_REGIONAL",

"FATO_ORCAMENTO_COMERCIAL"."SUPERVISOR",

"FATO_ORCAMENTO_COMERCIAL"."VOLUME_ORCADO",

"DIM_CALENDARIO"."ANO_ATIVO",

"DIM_CALENDARIO"."ANO_BISSEXTO",

"DIM_CALENDARIO"."DATA_ANO",

"DIM_CALENDARIO"."DATA_DIA",

"DIM_CALENDARIO"."DATA_MES",

"DIM_CALENDARIO"."DATA_SEMANA",

"DIM_CALENDARIO"."DATA_TRIMESTRE",

"DIM_CALENDARIO"."DIA_ATIVO",

"DIM_CALENDARIO"."DIA_CORRENTE",

"DIM_CALENDARIO"."DIA_UTIL",

"DIM_CALENDARIO"."DIA_UTIL_MES",

"DIM_CALENDARIO"."ESTACOES_NORTE",

"DIM_CALENDARIO"."ESTACOES_SUL",

"DIM_CALENDARIO"."FERIADO",

"DIM_CALENDARIO"."MES_ATIVO",

"DIM_CALENDARIO"."NOME_DIA_SEMANA",

"DIM_CALENDARIO"."NOME_DIA_SEMANA_RED",

"DIM_CALENDARIO"."NOME_MES",

"DIM_CALENDARIO"."NOME_MES_RED",

"DIM_CALENDARIO"."NUM_ANO",

"DIM_CALENDARIO"."NUM_DIA_ANO",

"DIM_CALENDARIO"."NUM_DIA_MES",

"DIM_CALENDARIO"."NUM_DIA_SEMANA",

"DIM_CALENDARIO"."NUM_MES",

"DIM_CALENDARIO"."NUM_NOME_DIA_SEMANA",

"DIM_CALENDARIO"."NUM_NOME_DIA_SEMANA_RED",

"DIM_CALENDARIO"."NUM_NOME_MES",

"DIM_CALENDARIO"."NUM_NOME_MES_RED",

"DIM_CALENDARIO"."NUM_SEMANA_ANO",

"DIM_CALENDARIO"."NUM_SEMANA_MES",

"DIM_CALENDARIO"."NUM_SEMESTRE",

"DIM_CALENDARIO"."NUM_TRIMESTRE",

"DIM_CALENDARIO"."QTD_DIAS_MES",

"DIM_CALENDARIO"."QTD_DIAS_UTEIS",

"DIM_CALENDARIO"."QTD_DIAS_UTEIS_COMERCIAL",

"DIM_CALENDARIO"."QTD_DIAS_UTEIS_FIM_MES"

FROM "FATO_ORCAMENTO_COMERCIAL"

INNER JOIN "DIM_ITENS"

ON (

"FATO_ORCAMENTO_COMERCIAL"."ID_ITEM" = "DIM_ITENS"."ID_ITEM"

)

INNER JOIN "DIM_CALENDARIO"

ON (

"FATO_ORCAMENTO_COMERCIAL"."DATA_ORCAMENTO" = "DIM_CALENDARIO"."DATA_DIA"

)

Comments (8)

photo
1

Hi Ederson,

Thanks for reaching out with the issue you're experiencing. There's a setting within Administration > Configuration > Views to disable the live data in the Prepare step:

2ce27fdbe695d039c9d353540341bd11

This can set to None to disable showing the live data. Give this a try and let me know if it helps your issue.

I look forward to your results of making the above change.

Regards,

Mike

photo
1

Hi Mike!Thanks for the feedback, I had already done this setup. I noticed that when I restart the application and then edit the View, then it is faster. I do not know if it is because it has no connected users or because it frees memory.

photo
1

Hi Ederson,

Thanks for your response. Do you know how much JVM is allocated to Yellowfin? You might want to look at increasing your JVM Max Memory. You also may want to look at Caching: Appending /info_cache.jsp to your Yellowfin login URL will pull up the information on the various internal cache's your instance is utilizing. In example, if you're having slowness when entering the Browse page check the 'Event Cache'. If your Cache hits percentage is low and your Events cached percentage is high, you may benefit from increasing this value. Read on here for more on Yellowfin Internal Cache Options.

Regards,

Mike

photo
1

Hi Ederson,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi!

I still have not got the time to check out these options. Next weeks I'll take up the subject and put the result here.


Thanks for the attention Mike.

photo
1

Hi Ederson,

Thanks for the update. I'll follow up again in a week if I don't hear back.

Regards,

Mike

photo
1

Hi Ederson,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi Ederson,

I'm going to go ahead and mark this one as Resolved, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike