#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

Community & Careers · Editorial question

surrealdbpaginationquery-optimization