Which code snippet best retrieves the total number of authors without loading all data?

Which code snippet best retrieves the total number of authors without loading all data?

• A. a!queryRecord Type( recordType: recordType!ABC_Author, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ), fetchTotalCount: true )
• B. a!queryRecord Type( recordType: recordType!ABC_Author, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1000 ), fetchTotalCount: false )
• C. a!queryRecord Type( recordType: recordType!ABC_Author, pagingInfo: a!pagingInfo( startIndex: 0, batchSize: 1 ), fetchTotalCount: true )
• D. a!queryRecord Type( recordType: recordType!ABC_Author, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ), fetchTotalCount: false )

Answer: (D)

You get the total number of records by asking for the total count while keeping the amount of data you load to a minimum. In Appian, a a!queryRecord can return totalCount when fetchTotalCount is true, and the pagingInfo controls how many records are actually loaded. By using a tiny batchSize (for example, 1) and starting at the first item, you avoid pulling all author records into memory, yet you still receive the total number of authors that match the query. This is the optimal approach: enable fetchTotalCount to true and keep the batchSize very small so only a minimal amount of data is loaded. If you turn fetchTotalCount off, you won’t get the total count at all, and loading a large batchSize defeats the goal of not loading everything.

You get the total number of records by asking for the total count while keeping the amount of data you load to a minimum. In Appian, a a!queryRecord can return totalCount when fetchTotalCount is true, and the pagingInfo controls how many records are actually loaded. By using a tiny batchSize (for example, 1) and starting at the first item, you avoid pulling all author records into memory, yet you still receive the total number of authors that match the query. This is the optimal approach: enable fetchTotalCount to true and keep the batchSize very small so only a minimal amount of data is loaded. If you turn fetchTotalCount off, you won’t get the total count at all, and loading a large batchSize defeats the goal of not loading everything.