Christian Paul Cosinas wrote:
Hi! How can I speed up my server's performance when I use offset and limit clause. For example I have a query: SELECT * FROM table ORDER BY id, name OFFSET 100000 LIMIT 10000 This query takes a long time about more than 2 minutes. If my query is: SELECT * FROM table ORDER BY id, name OFFSET 50000 LIMIT 10000 It takes about 2 seconds.
Please create a new thread rather than replying to someone elses post and changing the subject. These threads can sometimes get missed.
You do have an index on id and name don't you? -- Postgresql & php tutorials http://www.designmagick.com/
