FreeTDS Development Group

[michael.peppler AT bnpparibas.com]

Hi,

Replacing the Sybase libs with freetds might work, although the two aren't
fully binary compatible yet (AFAIK).

Have you considered using Ribo to capture the TDS traffic, and/or using the
MDA tables on the server to see which statements are taking too long?

Michael




Internet
guru AT Sisis.de@lists.ibiblio.org - 20/04/2006 09:41


Please respond to Matthias.Apitz AT Sisis.de; Please respond to
       freetds AT lists.ibiblio.org

Sent by:    freetds-bounces AT lists.ibiblio.org

To:    freetds

cc:


Subject:    [freetds] FreeTDS && Sybase's ESQL/C



Hello,

This is only some background (and not advertisement :-))
We're a software house in the library market with some big application
build on top of ESQL/C and which is working with Informix, Oracle and
Sybase
(actualy ASE 12.5.x). We have some serious performance issues with Sybase
and my idea was somehow to easy capture all SQL send over to Sybase
ASE (together with duration and timestamps) to get an idea what are
all these hundred connections at a given moment, when the performance
drop rises, have sent over to ASE.

Searching with Google I have hit FreeTDS and thought that I could
replace Sybase's CT-library, which are shared libs on SunOS or Linux
with the FreeTDS libraries. Sybase's ESQL/C itself is just setup on
top of Sybase's CT-library. It seems that some of the ct_xxxxx
functions are implemented in FreeTDS, but not all...

Do I have the wrong idea or I'm missing something?

Thx in advance

 matthias

--
Matthias Apitz / Sisis Informationssysteme GmbH
ein Tochterunternehmen der OCLC PICA B.V. Leiden (NL)
D-82041 Oberhaching, Gruenwalder Weg 28g
Fon: +49 89 / 61308-351, Fax: -399, Mobile +49 170 4527211
http://www.sisis.de/~guru/
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
 http://lists.ibiblio.org/mailman/listinfo/freetds



This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.