| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Andy Wallace | Date: | September 5 2012 9:05pm |
| Subject: | Re: Understanding Slow Query Log | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • Understanding Slow Query Log | Adarsh Sharma | 1 Sep |
| • Re: Understanding Slow Query Log | yoku ts | 1 Sep |
| • Re: Understanding Slow Query Log | Suresh Kuna | 1 Sep |
| • RE: Understanding Slow Query Log | Rick James | 4 Sep |
| • Re: Understanding Slow Query Log | Adarsh Sharma | 5 Sep |
| • Re: Understanding Slow Query Log | Manuel Arostegui | 5 Sep |
| • Re: Understanding Slow Query Log | Adarsh Sharma | 5 Sep |
| • Re: Understanding Slow Query Log | Adarsh Sharma | 5 Sep |
| • RE: Understanding Slow Query Log | Rick James | 5 Sep |
| • Re: Understanding Slow Query Log | Andy Wallace | 5 Sep |
| • RE: Understanding Slow Query Log | Rick James | 5 Sep |
| • Re: Understanding Slow Query Log | Andy Wallace | 5 Sep |