Multiple DB calls

Technical queries
, , ,
#1

Hi Team,

We have set logger level to DEBUG and we have found multiple db calls in Helical Insight logs for single execution of report. We are seeing 03 db calls for same sql. Can you please help on this ?
We are using Helical Insight 4.1 GA Enterprise edition.

Thank You,
Netta.

#2

Hello ,

I think you are assuming if SQL is present 3 time in logs , it executes 3 times on the DB server. But it is not the case since you have kept in debug mode, It will print info, execution time etc in the logs for the same SQL. But it will run and executes always one time in the DB. We recommend to use to keep logger as error mode always.

Debug mode can be used when you trying to fix some issues , otherwise debug mode generates lots of logs which makes server slow.

Thanks,
Helical Team.