FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On 02 Mar 2003 22:01:37 +0100, Frediano Ziglio <freddyz77 AT tin.it> wrote:
> I spent some time on numeric performance.
> I didn't implement direct numeric -> integer conversion however results
> seem good (I reimplemented numeric -> string used very often in
> conversion from numeric).
> Some performance test can be retested (I remember time ago a insert test
> with a lot of numeric fields).
> I written function from scratch and seem to work well... after some bug
> fix...

Nice work, Freddy!  I guess we don't need a math library after all?  

I s/interation/iteration/ and got this for varchar (important for bcp -c):

$ ./convert 10000 2>/dev/null |grep iterations |grep varchar |sort -n 
   10987 iterations/second converting         money => varchar.
   84996 iterations/second converting        binary => varchar.
   85002 iterations/second converting      datetime => varchar.
   85252 iterations/second converting         image => varchar.
   86350 iterations/second converting smalldatetime => varchar.
  266007 iterations/second converting       varchar => smalldatetime.
  314416 iterations/second converting     long long => varchar.
  316586 iterations/second converting           int => varchar.
  322154 iterations/second converting       tinyint => varchar.
  322695 iterations/second converting      smallint => varchar.
  325881 iterations/second converting          real => varchar.
  369180 iterations/second converting       varchar => datetime.
  372592 iterations/second converting         float => varchar.
  399968 iterations/second converting    smallmoney => varchar.
  441636 iterations/second converting       varchar => numeric.
  450207 iterations/second converting       varchar => decimal.
  791020 iterations/second converting       varchar => money.
  794722 iterations/second converting       decimal => varchar.
  795038 iterations/second converting       numeric => varchar.
 1401348 iterations/second converting       varchar => image.
 1414223 iterations/second converting       varchar => binary.
 1547257 iterations/second converting       varchar => text.
 1552296 iterations/second converting       varchar => smallmoney.
 1556675 iterations/second converting       varchar => char.
 1577518 iterations/second converting       varchar => float.
 1579270 iterations/second converting       varchar => real.
 1650424 iterations/second converting          text => varchar.
 1651528 iterations/second converting          char => varchar.
 1875136 iterations/second converting           bit => varchar.
 3299224 iterations/second converting       varchar => long long.
 4648974 iterations/second converting       varchar => smallint.
 4661892 iterations/second converting       varchar => tinyint.
 4803096 iterations/second converting       varchar => int.
 5347490 iterations/second converting       varchar => bit.

With Bill's 64-bit money, we'll have knocked off the worst offenders.  

--jkl