FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Hi,

Haven't responded on this to date, but I'm working on the code to see how
things can be improved. 
>From first looks I can see that we do a lot of work that may well be
unnecessary. 
There's an awful lot of malloc-ing , memcpy-ing, memset-ing and free-ing of
storage that takes please for every column on every row that we bcp out. 

With the convert routines , for every convert to char type there's also
another malloc & free (much complained about at the time by one Frediano, I
recall). Converting dates to strings is always going to be difficult, as is
possibly numeric to char conversions. 

Jim's evidence points to convert as the main culprit. I'll try some stuff
out tomorrow and let you know how I get on.

Oh BTW, our performance relative to Sybase BCP is not nearly so bad. A few
tests today showed us only about 30% slower...

Bill

> -----Original Message-----
> From: Castellano, Nicholas [SMTP:Nicholas_Castellano AT acml.com]
> Sent: Wednesday, February 05, 2003 8:19 PM
> To:   'freetds AT lists.ibiblio.org'
> Subject:      gmp (was RE: [freetds] BCP performance)
> 
> Yes, this would be very handy for implementing the missing dbmny*()
> arithmetic functions, among other things.  It's not clear to me that there
> would be any performance benefit, though.
> 
> Cheers,
> --nick
> 
> -----Original Message-----
> From: freetds-admin AT lists.ibiblio.org
> [mailto:freetds-admin AT lists.ibiblio.org] 
> Sent: Wednesday, February 05, 2003 3:09 PM
> To: 'freetds AT lists.ibiblio.org'
> Subject: RE: [freetds] BCP performance
> 
> 
> http://www.swox.com/gmp/
> 
> I'm going to compare some results.  It's hard to believe we shouldn't use
> gmp, even though it introduces a dependency.  
> 
> --jkl
> 
> 
> 
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or
> agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
> is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds