Re: 0.91 freebcp performance
Matthew <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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 > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds