[freetds] 0.91 freebcp performance

Matthew matthew.green at datamartcomputing.com
Sat Jun 20 09:40:20 EDT 2015

Hi Ray,

I did come across performance problems when compared to Sybase bcp but 
those were mostly around text and image data types. Those problems 
appeared to be fixed, in my testing, or at least greatly improved when I 
tried a nightly from a few weeks ago.

What's the definition of the table you are using and which flags are you 
using? Can you take a look inside the Sybase server and see what it's 
waiting for when you use freetds and which packet size the connection is 
using? I assume your comparison is from the same machine and it's not 
the case that you're running the Sybase bcp locally and freetds 
remotely? Can you see if both are using fast bcp, i.e. minimally logged 
or are both using fully logged?

Just some ideas unless someone else has got better ones!



On 20/06/15 15:18, Ray Rankins wrote:
> Just tested running a large bcp with 0.91 freebcp and the performance was awful.
> Took 1.5 hours to load 5 million rows (conversely, Sybase bcp loaded the same file in 1.5 minutes).
> Is there some setting that might be on during compile that would cause freebcp to run slow.
> I checked and double checked that the debug flags were not enabled (have made that mistake before) and they were not.
> Are there any compile time options that could slow down freebcp that I should make sure are disabled when I compile it?
> -Ray
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

More information about the FreeTDS mailing list