Thread 1 : gets offset 0 limit 5000
Thread 2 : gets offset 5000 limit 5000
Thread 3 : gets offset 10000 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 threads consuming from that queue... it will work better.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to