---
title: Business Rules Using GlideRecord And getRowCount
description: "Impact Area Scalability  Severity Medium Affected Element Business rules ## Rule number **SN-0015** ## 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/business-rules-using-gliderecord-and-getrowcount/"
updated: "2025-03-21"
category: Rules
---

# Business Rules Using GlideRecord And getRowCount

Impact Area

Scalability 

           Severity

Medium

           Affected Element

Business rules

## Rule number

**SN-0015**

## 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

15 min