|
From: SourceForge.net <no...@so...> - 2011-06-14 21:59:00
|
Bugs item #2824545, was opened at 2009-07-21 08:32 Message generated for change (Comment added) made by p_ansell You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=814189&aid=2824545&group_id=142631 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Configuration files >Group: v1.0 >Status: Closed >Resolution: Postponed Priority: 5 Private: No Submitted By: Peter Ansell (p_ansell) Assigned to: Peter Ansell (p_ansell) Summary: Add GROUP BY to any queries that include offset Initial Comment: The use of OFFSET won't always be correct unless there is a GROUP BY clause... This will make queries slower, but if users are expecting offset to work correctly then the performance loss has to be taken. ---------------------------------------------------------------------- >Comment By: Peter Ansell (p_ansell) Date: 2011-06-15 07:58 Message: queries do not complete because databases are very inefficient at computing results for almost all queries when group by is added ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=814189&aid=2824545&group_id=142631 |
