Thread 1 : gets offset 0 limit 5000
Thread 2 : gets offset 5000 limit 5000
Thread 3 : gets offset 1 limit 5000
Would there be any other faster way than what It thought?
Yeah, sure, use a thread which does the whole query (maybe using a
cursor) and fills a queue with the results, then N
On Tue, May 16, 2006 at 07:20:12PM -0700, Craig A. James wrote:
> >Why I want to use offset and limit is for me to create a threaded
> >application so that they will not get the same results.
>
> In order to return rows 1 to 15000, it must select all rows from zero
> to 15000 and then discard
Christian Paul Cosinas wrote:
I am creating an application that gets the value of a large table and write
it to a file.
Why I want to use offset and limit is for me to create a threaded
application so that they will not get the same results.
For example:
Thread 1 : gets offset 0 limit 5000
Thr
: [PERFORM] Speed Up Offset and Limit Clause
Why do you want to use it this way ?
Explain what you want to do, there probably is another faster
solution...
On Thu, 11 May 2006 16:45:33 +0200, Christian Paul Cosinas
<[EMAIL PROTECTED]> wrote:
> Hi!
>
> How can I speed
"Christian Paul Cosinas" writes:
> 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 10 LIMIT 1
>
> This query takes a long time about more than 2 minutes.
>
> If my q
Why do you want to use it this way ?
Explain what you want to do, there probably is another faster
solution...
On Thu, 11 May 2006 16:45:33 +0200, Christian Paul Cosinas
<[EMAIL PROTECTED]> wrote:
Hi!
How can I speed up my server's performance when I use offset and limit
c
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 10 LIMIT 1
This query takes a long time about more than 2 minutes.
If my query is:
SELECT * FROM ta
