Query Builder limit and offset behavior with high-volume datasets
CodeIgniter's Database Query Builder provides limit() and offset() methods to abstract result constraints across different database drivers. This functionality is frequently used in conjunction with the Pagination class to manage large record sets by calculating the starting index and page size. While these methods ensure cross-database compatibility, the un