[freetds] Cursors in freetds

Steven Orton sorton9999 at usa.net
Sun Jun 27 23:50:02 EDT 2004

Hey Bill,

  This is great news!!  I was one interested party that was great disappointed
to find out that FreeTDS did not have cursors available.  It hurt so much that
I had to scrap plans to use this driver and went to a commercial vendor.  I
would love to see this functionality be incorporated into the ODBC module as
well.  I am not up on the technical issues, but as a user, it would be good to
have multiple resultsets handled with a single connection.  The API I'm using
does not handle this and I'm not even sure that the commercial driver does
either.  The main reason I'm interested in this is simply one of speed.  We
deal in multiple connections with multiple machines all hitting one backend
DB.  It seems pointless to connect and dump the connection with every query we
need to run.  Connect times are typically the most expensive and it would
boost our throughput immensely to re-use the connection.


"Thompson, Bill D (London)" <bill_d_thompson at ml.com> wrote:

> Hi all,
> I've got a patch ready to submit, which gives us full access to server side
> cursors through the ct-library API.
> This enables us to handle multiple active result sets through a single
> connection.  
> As this is one of the trumpeted features of ADO.NET 2.0 , I think we should
> be pretty chuffed about being able to do it too!
> I know it sounds like a radical departure, but I would like to "walk
> through" the design of this with any interested parties before unleashing
> the patch on an unsuspecting world.
> I'd also like to know how this fit in with the ODBC driver - will it
> our implementation significantly to have cursors available ?
> I'll prepare an outline document on how I've changed things, and why. 
> I'll forward it to interested parties, so if you consider yourself to be
> of those, just let me know.
> Best wishes,
> Bill Thompson
> GMI Technology
> Merrill Lynch Europe
> +44 207 995 8307
> For very important information relating to this e-mail please click on this
> link:  http://www.ml.com/legal_info.htm
> If you are not an intended recipient of this e-mail, please notify
> the sender, delete it and do not read, act upon, print, disclose,
> copy, retain or redistribute it.
> Click here for important additional terms relating to this e-mail.
>      <http://www.ml.com/email_terms/>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

Steven Orton
sorton9999 at usa.net
INEPTITUDE: If you can't learn to do
 something well, learn to enjoy doing
 it poorly.
"Put your hand on a hot stove for a minute,
 and it seems like an hour.
 Sit with a pretty girl for an hour, and it
 seems like a minute. THAT'S relativity."
        -- Albert Einstein

More information about the FreeTDS mailing list