Editing Non-Functional Requirements (section)

== 2. Performance ==

<span id="nfr-perf-01-generation-throughput"></span>
=== NFR-PERF-01 — Generation throughput ===

'''Requirement:''' The system should generate and insert at least 1,000 primes per second under normal operating conditions (single-user, unloaded PostgreSQL on localhost).<br />
'''Rationale:''' There are approximately 50 million primes below 10^9. Without a throughput target the system may be functionally correct but practically unusable.<br />
'''Test approach:''' Time a generation run of the first 10,000 primes; divide by elapsed seconds.<br />
'''Priority:''' Should Have<br />
'''Source:''' Best-practice default [UNCONFIRMED — no target specified in source]<br />
'''Status:''' Open — target must be agreed with the system owner.

<span id="nfr-perf-02-report-generation-time"></span>
=== NFR-PERF-02 — Report generation time ===

'''Requirement:''' A report covering up to 1 million stored primes should complete within 5 minutes.<br />
'''Rationale:''' A batch report that runs overnight is operationally acceptable; one that runs for days is not.<br />
'''Test approach:''' Seed 1,000,000 rows; time a full report run.<br />
'''Priority:''' Should Have<br />
'''Source:''' Best-practice default [UNCONFIRMED]<br />
'''Status:''' Open.

<span id="nfr-perf-03-database-query-response"></span>
=== NFR-PERF-03 — Database query response ===

'''Requirement:''' The <code>SELECT prime WHERE ident = :n</code> divider lookup should return in under 50 ms at any point in the generation run.<br />
'''Rationale:''' This query is called once per trial division step; if it is slow, the entire sieve is slow.<br />
'''Test approach:''' Run EXPLAIN ANALYZE on the query with a populated table; check absence of sequential scan on <code>primes.primes</code>.<br />
'''Priority:''' Must Have<br />
'''Source:''' Algorithm design analysis<br />
'''Status:''' Open — no index on <code>ident</code> is defined in <code>primes_schema.sql</code>; a sequential scan is likely. This is a defect.


-----

<span id="reliability-and-availability"></span>