From: Andy Wallace
Date: September 5 2012 9:05pm
Subject: Re: Understanding Slow Query Log
List-Archive: http://lists.mysql.com/mysql/228120
Message-Id: <5047BE8B.9010508@ihouseweb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ok, this raises a question for me - what's a better way to do pagination?

On 9/5/12 2:02 PM, Rick James wrote:
> * LIMIT 0, 50 -- are you doing "pagination" via OFFSET?  Bad idea.



-- 
Andy Wallace
iHOUSEweb, Inc.
awallace@stripped
(866) 645-7700 ext 219
--
"Sometimes it pays to stay in bed on Monday, rather than spending the rest of the week debugging Monday's code."
- Christopher Thompson