On 9/18/06, PY <[EMAIL PROTECTED]> wrote:
Hi All, I have a problem about LIMIT & OFFSET profermance.
Is there any chance you can use an index on your select? If it has an index it might be able to calculate the position of the offset and not have to read the entire result set. This is just a guess though. I'm not sure if sqlite is able to do that. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
