Issue:Offset should be implemented at SQL level, not PHP
From FollowTheScore
Revision as of 13:06, 31 October 2007 by Ycombarnous (talk | contribs) (New page: {{Issue |Type = Bug |Extension = DPL |Version = 1.5.1 |Description = Offset higher than max result limit outputs nothing |Status = open }} == Problem == If Max resu...)
Description: | Offset higher than max result limit outputs nothing |
Extension / Version: | DPL / 1.5.1 |
Type / Status: | Bug / open |
Problem
If Max results for DPL is set to 500, looking for results in range 600-800 is impossible. The reason being that the offset is implemented at PHP level, not SQL level.
Any reason for this, as Mysql offers [LIMIT {[offset,] row_count | row_count OFFSET offset}]