Andre Dev Log⚡ ServiceNow Performance Optimization
Why does ServiceNow get slow?
Performance issues usually come from inefficient database queries, excessive client-server round trips, and heavy ACL evaluation. This guide clusters the posts in this repo that focus on those exact failure modes.
What you’ll learn
- How query structure affects database cost in ServiceNow.
- When to use GlideAggregate instead of counting in loops.
- How to reduce unnecessary lookups in client-side scripts.
- Why ACL logic can become both a security and performance problem.
Querying ref_ Fields on Extended Tables
ref_ queries are one of those ServiceNow features that are useful, slightly obscure, and easy to misuse. They show up when you start from a base table such as task, but …
ACL Misconceptions That Hurt Performance
ACLs are easy to treat as a pure security feature and forget that they also sit on a hot path. When an instance loads a form, renders a list, or reads fields through …
Minimize Server Lookups in Client Scripts
Client scripts get slow and noisy when every small decision turns into another server call. Most of the time, the real problem is not the API. It is choosing the wrong …
Querying Tables Best Practices
Querying tables is one of those things that looks harmless until the same script runs against production-sized data. A query that feels fine with a few hundred records …