Database Queries Not Segregated (DB Tuning)
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.
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
Thanks Wolfgang for helping out.
I am sending this info to my team members for review.
Regards,
Rajesh.
