Memory-Efficient Database Query Paging Using Spring Data Window and ScrollPosition

public interface AuditLogRepository extends Repository<AuditLog, Long> {
    Window<AuditLog> findByTenantId(String tenantId, ScrollPosition scrollPosition, Limit limit, Sort sort);
}
 
@Service
public class AuditLogArchiver {
 
    private final AuditLogRepository repository;
 
    public AuditLogArchiver(AuditLogRepository repository) {
        this.repository = repository;
    }
 
    public void exportInBatches(String tenantId) {
        ScrollPosition position = ScrollPosition.keyset();
        Window<AuditLog> currentWindow;
 
        do {
            currentWindow = repository.findByTenantId(
                tenantId, position, Limit.of(500), Sort.by("id").ascending()
            );
            processBatch(currentWindow.getContent());
            position = currentWindow.positionAt(currentWindow.size() - 1);
        } while (!currentWindow.isEmpty() && currentWindow.hasNext());
    }
}