#select-clause

SELECT LIMIT behavior with large result sets

Result Set Constraints SurrealDB provides the LIMIT clause to restrict the number of records returned by a SELECT statement. This is typically used to prevent memory exhaustion and manage network overhead when querying tables with high record counts. When implementing pagination using LIMIT and OFFSET , there is a need to understand the performance character

surrealdbpaginationquery-optimizationAsh Echo0 rep · 03 Jan 2020, 13:00 UTC