---
title: Event Script Action Using GlideRecord And getRowCount
description: "Impact Area Scalability Severity Medium Affected Element Script actions ## Rule ID **SN-0180** ## Impact The `GlideRecord.getRowCount()` works by getting the whole result set without using the build-in arithmetic functions of the database. `GlideAggregate` does use the database, therefore is often drastically faster. The…"
url: "https://community-staging.qualityclouds.com/qcdocs/qc/servicenow-rules/event-script-action-using-gliderecord-and-getrowcount/"
updated: "2025-03-21"
category: Rules
---

# Event Script Action Using GlideRecord And getRowCount

Impact Area

Scalability

           Severity

Medium

           Affected Element

Script actions

## Rule ID

**SN-0180**

## Impact

The `GlideRecord.getRowCount()` works by getting the whole result set without using the build-in arithmetic functions of the database. `GlideAggregate` does use the database, therefore is often drastically faster. The exception to this recommendation is if you intend to loop through the records and process them anyway

## Remediation

Replace GlideRecord with `GlideAggregate` and a `COUNT` aggregate to improve performance. This could make a large impact when working on tables with a high record count.

### Time to fix

20 min