# USQL with application/internalApplicationId: which is more efficient?

**URL:** <https://community.dynatrace.com/t/usql-with-application-internalapplicationid-which-is-more-efficient/31603>\
**Category:** Real User Monitoring\
**Tags:** real-user-monitoring-classic, application-monitoring, usql\
**Created:** [May 26, 2021, 4:01pm UTC](https://community.dynatrace.com/t/usql-with-application-internalapplicationid-which-is-more-efficient/31603 "2021-05-26T16:01:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Post date:** [May 26, 2021, 4:01pm UTC](https://community.dynatrace.com/t/usql-with-application-internalapplicationid-which-is-more-efficient/31603/1 "2021-05-26T16:01:35Z")

</div>

When using USQL with an application where condition, eg.

SELECT \* from useraction where application is “applicationName”

if one changes the applicationName, the query will stop giving results. I have changed the queries to use internalApplicationId instead, and while it is not easily understandable, it does the job.

I had the initial visual perception that internalAppplicationId was loading faster in a Dashboard where I still had both of the approaches, but now that I have done more tests, it doesn’t seem so clear.

The question is thus if anyone knows if one of the approaches is faster, or more efficient?

---

<div class="post-metadata">

**Author:** ![ChadTurner](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/chadturner/32/161_2.png) [@ChadTurner](https://community.dynatrace.com/u/ChadTurner)\
**Post date:** [May 26, 2021, 8:18pm UTC](https://community.dynatrace.com/t/usql-with-application-internalapplicationid-which-is-more-efficient/31603/2 "2021-05-26T20:18:28Z")

</div>

really the only benefit is if your organization changes the Name frequently. If you base it off of ID# then that ID will always exists (unless the application is deleted) no matter how many name changes it may go through.

I have not see any evidence that would conclude one method loads faster then the other.

---

<div class="post-metadata">

**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\
**Post date:** [May 26, 2021, 9:29pm UTC](https://community.dynatrace.com/t/usql-with-application-internalapplicationid-which-is-more-efficient/31603/3 "2021-05-26T21:29:25Z")

</div>

[@ChadTurner](https://community.dynatrace.com/user/14877)

Reminded me of an interesting twist: if I delete an application and create another one with the same name, will the USQL by application name gather stats from both of them? The ID approach would certainly not work…
