JezK
Edit File: seemtooslow.html
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Slow connection or data retrieval</title><link rel="stylesheet" type="text/css" href="userguide.css" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="home" href="index.html" title="FreeTDS User Guide" /><link rel="up" href="troubleshooting.html" title="Chapter 8. Troubleshooting" /><link rel="prev" href="pagenodata.html" title=""Page contains no data"" /><link rel="next" href="help.html" title="Chapter 9. Getting Help" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Slow connection or data retrieval</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="pagenodata.html">Prev</a> </td><th width="60%" align="center">Chapter 8. Troubleshooting</th><td width="20%" align="right"> <a accesskey="n" href="help.html">Next</a></td></tr></table><hr /></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="seemtooslow"></a>Slow connection or data retrieval</h2></div></div></div><p><span class="productname">FreeTDS</span> is <span class="emphasis"><em>not</em></span> slow. We know this because we've tested it. It's measurably slower than the vendors' products for some operations, but it's not noticeably slower and it's certainly no laggard. If your experience is different, if you're waiting 30 seconds for simple operations or minutes instead of seconds for for query results, something is up with your setup. There are two likely culprits.</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: bullet; "><li class="listitem" style="list-style-type: disc"><p>Logging. If everything seems a bit sluggish, check to make sure logging is turned off. <code class="envar">TDSDUMP</code> should not be defined, and there should be no <code class="literal">dump file</code> mentioned in <code class="filename">freetds.conf</code>. You can double-check by setting <code class="envar">TDSDUMPCONFIG</code> temporarily, which will log only the startup process.</p></li><li class="listitem" style="list-style-type: disc"><p>DNS. If connecting to the server takes 30 seconds or 1 minute, you could do worse than to check your <code class="filename">resolv.conf</code>. Use <span class="command"><strong>host</strong></span> or <span class="command"><strong>nslookup</strong></span> to confirm that <span class="productname">FreeTDS</span> can actually resolve the name/address you provided in <code class="filename">freetds.conf</code>.</p></li><li class="listitem" style="list-style-type: disc"><p>Packet size. The default packet size setting in <code class="filename">freetds.conf</code> (see <code class="literal">initial block size</code>) is usually fine. Slowness can potentially be due to multiple packet to use. Under <span class="productname"><acronym class="acronym">GNU</acronym>/Linux</span> system we use an optimization to reduce network traffic; you shouldn't see much difference using this system.</p></li></ul></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="pagenodata.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="troubleshooting.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="help.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">"Page contains no data" </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Chapter 9. Getting Help</td></tr></table></div></body></html>