Skip to Content.
Sympa Menu

freetds - Re: Fetch records in TDS 7.0 ???

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James K. Lowden <jklowden AT speakeasy.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Fetch records in TDS 7.0 ???
  • Date: Sat, 6 Apr 2002 21:29:24 -0500


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




Archive powered by MHonArc 2.6.24.

Top of Page