FreeTDS Development Group

[James K. Lowden <jklowden AT speakeasy.org>]

On Sat, 6 Apr 2002 20:39:47 -0500 "Fernando" <nulll AT bol.com.br> wrote:
> 
>    If I submit a statment(select) that return 100.000 lines, I can fetch
> group of lines or I have wait by all lines ?

Fernando, 

The server listens to your query and composes a result set.  If the result
set is not sorted (no ORDER BY), the server will start returning rows as
soon as it finds some that meet your criteria.  If the result set *is*
sorted, the server has to wait until it finds all your rows, then sort
them, then send you the rows.  Frequently, sorting leads to waiting.  

Does that answer your question?

Regards, 

--jkl