Business Rules Using GlideRecord And getRowCount

Table of Contents

Rule number
Impact
Remediation

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.