FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

On 9 Sep 2002, Frediano Ziglio wrote:

>   - dynamic query, even for mssql
I would love to know how TDS 7.0 does this, from the network dumps I've 
done, it seems to be all client side.  It does not appear to be possible 
in TDS 4.2 so this is a 7.0/8.0 extension if anything.

>   - cursor support (0.61? perhaps not...)
Indeed.  This is a big hole in our functionality.

>   - limit the copy of data, now we do
>     1- copy from wire to tds buffer
>     2- copy to tds buffer to temp buffer
>     3- copy to temp buffer to client
>     I'd like to remove 2 on 0.61 (as 0.53 do). Be able to copy from wire
> to client is perhaps possible... but not in 0.61...

dblib supports row buffering which makes it hard to accomplish this, but 
perhaps a short cut if row buffering is off, then take the shorter path.

I might as well through in ctlib array binding which can yield similar 
speed ups (by no having to return to the client after each row) and is 
important for some apps, not sure if it's 0.61 or beyond though.

> freddy77
> 

Brian