[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