Andre Dev LogPerformance
6 items tagged with "Performance"
Posts
When to Use addEncodedQuery() and applyEncodedQuery()
Encoded queries are one of the fastest ways to move a filter from a list view into a script.
Use GlideAggregate Instead of GlideRecord.getRowCount()
When a server-side script only needs to know how many records match a condition, GlideRecord with getRowCount() is usually the wrong tool. It works, but it is a …
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 …