[freetds] FreeTDS running very slow on new server

Magnus Palm Magnus.Palm at hs.hj.se
Tue Apr 3 02:07:34 EDT 2007


Solved it finally.
One little row in the configuration was the reason that this script was executing so slow.

If anyone of you stumble upon the same trouble, make sure the line 

initial block size = 512

is

; initial block size = 512

cheers

/Magnus


>>> "Magnus Palm" <Magnus.Palm at hs.hj.se> 2007-04-02 16:50:43 >>>
Hi! 

Have this really annoying problem. Been using FreeTDS with PHP on Solaris for quite some time now. Been working great.

But recently we got a new server and after installing everything I noticed that it was running rather slow.

For example. Have a php-script that runs about 120 queries. This script takes about 6 seconds to execute on the new server. On the old one the same script took about 0,6 seconds.

Both machines run Solaris 9. 

Have tried compiling FreeTDS by hand and installing FreeTDS using CSW (pkg-get).

The old server was at ~90-100% cpu load and the new one is at ~15-20%.

Regards
Magnus Palm

--------------------------------------------------------------
Magnus Palm
Webbutvecklare
Högskoleservice
magnus.palm at hs.hj.se 
036 - 10 10 76
--------------------------------------------------------------



_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org 
http://lists.ibiblio.org/mailman/listinfo/freetds 





More information about the FreeTDS mailing list