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.
