[freetds] FreeTDS on Core 2 Duo problem
James K. Lowden
jklowden at freetds.org
Mon Feb 19 06:28:27 EST 2007
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
More information about the FreeTDS
mailing list