Difference between revisions of "Issue:Offset should be implemented at SQL level, not PHP"
From FollowTheScore
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...) |
(No difference)
|
Revision as of 13:06, 31 October 2007
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}]