Firebird OFFSET/FETCH pagination and JDBC driver handling of large offsets
Goal: Retrieve a consistent page of data from a large Firebird table using the OFFSET/FETCH clause through a JDBC connection, while maintaining deterministic order and acceptable response time. Constraints: The OFFSET/FETCH syntax requires an explicit ORDER BY to guarantee stable pagination; without it the server may return rows in an undefined order, making