Edit or clone view is very slow
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"
)
The same problem 
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:
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
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:
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
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.
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.
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
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
Hi Ederson,
I just wanted to check in and see how things are going with this.
Regards,
Mike
Hi Ederson,
I just wanted to check in and see how things are going with this.
Regards,
Mike
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.
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.
Hi Ederson,
Thanks for the update. I'll follow up again in a week if I don't hear back.
Regards,
Mike
Hi Ederson,
Thanks for the update. I'll follow up again in a week if I don't hear back.
Regards,
Mike
Hi Ederson,
I just wanted to check in and see how things are going with this.
Regards,
Mike
Hi Ederson,
I just wanted to check in and see how things are going with this.
Regards,
Mike
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
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
Replies have been locked on this page!