Skip to Content.
Sympa Menu

freetds - Re: [freetds] 0.91 freebcp performance

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Matthew <matthew.green AT datamartcomputing.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] 0.91 freebcp performance
  • Date: Sat, 20 Jun 2015 15:40:20 +0200

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!

Cheers,

Matthew


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





Archive powered by MHonArc 2.6.24.

Top of Page