Hi all,
I was going through database dashboard of a mobile application.
Following are the snapshots:
You can see too many similar queries are being executed but DT is showing them as distinct rather than segregating them as one.
I would like to why is this happening? Is there something going wrong (with DB)? Please suggest.
[Also, here is an APM blog about DB tuning:
http://apmblog.dynatrace.com/2011/07/05/beyond-persistence-how-to-exploit-your-database-for-better-performance/
I hope this is not n+1 query problem though.]
Thanks in advance.
R.S.
Answer by Wolfgang G. ·
Hi Rajesh,
I guess this is because those are in fact distinct queries as the LIKE clause is different. You can see in the executions column that some are executed multiple times and then the count is increased. I would suggest to rewrite the query to use a parameter also for LIKE
Hope that helps,
Wolfgang
DECEMBER 12, 10:00 AM GMT / 2:00 PM ET
Learn how Dynatrace Real User Monitoring automatically detects errors that impact your end users caused by erroneous 3rd party or CDNs.
December 10, 4:00 pm CET / 10:00 am ET
Register here
Learn how Dynatrace Real User Monitoring automatically detects errors that impact your end users caused by erroneous 3rd party or CDNs.
December 10, 4:00 pm CET / 10:00 am ET
Register here
Learn how Dynatrace Real User Monitoring automatically detects errors that impact your end users caused by erroneous 3rd party or CDNs.
December 10, 4:00 pm CET / 10:00 am ET
Register here