FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Medvidek Pu wrote:
> The connect is fast, the use command is fast, the query is slow. You can
> see the part of the dump in the following listing. ... it is this time
> that keeps growing longer and longer with subsequent queries sometimes
> dropping to reasonable time but then again raising.
> 
> 09:10:19.987646 ct_send() succeeded
> 09:10:19.987670 ct_results()
> 09:10:24.259829 Received header

As you probably know, FreeTDS is only waiting during that time.  The
client is idle and the network is idle.  Only the server is doing
anything.  I can't think of anything the client could do that would delay
the arrival of the server's response.  

I think it's an interesting problem.  In your shoes I would focus my
attention on server resources.  My favorite tool for Microsoft servers is
the Profiler.  

HTH.  

--jkl