Function getTotalResultRowCount

src/models/evalPerformance.ts:73–101

(evalId: string)

 * Use this for progress tracking when iterating over all results (e.g., sharing).
 */
export async function getTotalResultRowCount(evalId: string): Promise<number> {
  const cacheKey = `total:${evalId}`;
  const cached = totalRowCountCache.get(cacheKey);

  if (cached && Date.now() - cached.timestamp < CACHE_TTL) {
    logger.debug(`Using cached total row count for eval ${evalId}: ${cached.count}`);
    return cached.count;
  }

  const db = await getDb();
  const start = Date.now();

  // Count all result rows - use this when iterating over all results
  const result = await db
    .select({ count: sql<number>`COUNT(*)` })
    .from(evalResultsTable)
    .where(sql`eval_id = ${evalId}`)
    .all();

  const count = Number(result[0]?.count ?? 0);
  const duration = Date.now() - start;

  logger.debug(`Total row count query for eval ${evalId}: ${count} in ${duration}ms`);

  // Cache the result
  totalRowCountCache.set(cacheKey, { count, timestamp: Date.now() });

  return count;
}

export function clearCountCache(evalId?: string) {
  if (evalId) {