Re: [Sqlrelay-discussion] Manifold FreeTDS symptoms

[Cameron L. <cla...@gm...>]

On Wed, Jan 27, 2010 at 2:27 PM, David Muse <dav...@fi...>wrote:

>  The only introspection that's available in SQL Relay is to turn on
> server-side debugging and dig through the logs.  There's no dashboard or
> anything like that.  I'm not sure how useful it would be if there was,
> queries would go flying by too quickly to make sense of them.  There is a
> stats monitor that shows how many connections and cursors and such are open,
> but there's a bug in it now and it's not reliable.
>
> Freetds only supports 1 cursor per database connection, but Zope and other
> frameworks use multiple cursors to handle nested queries.  SQL Relay
> provides a multi-cursor interface to
>
...

> Also, what version of freetds are you using?
>
> A quick, reliable solution would be to build SQL Relay against sybase
> client libs rather than freetds and use that.  It supports multiple cursors
> per connection.  But, there could certainly be licensing issues there.
>    ...
>

 sqlrelay-freetds 1:0.38-3ubuntu1; that's the version, as near as I can
tell.

"A quick, reliable solution ...":  at one level is this quick?  I currently
am running against Debian packages, as you can see.  Is "to build SQL Relay
..." something *I* would do, or a change you're proposing for the reference
sources of SQL Relay, or ...?  I'm happy to work in C, and to generate
libraries myself; I just want to be sure I understand your description.

Many thanks, by the way, for these valuable details.