FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

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...

$ ./convert 200000 > out.txt
$ cat out.txt | grep 'numeric =>' | grep interations | sort -n
 1024502 interations/second converting       numeric => smallmoney.
 1029043 interations/second converting       numeric => money.
 1225625 interations/second converting       numeric => long long.
 1273926 interations/second converting       numeric => float.
 1274851 interations/second converting       numeric => real.
 1319950 interations/second converting       numeric => text.
 1328957 interations/second converting       numeric => varchar.
 1330105 interations/second converting       numeric => char.
 1449832 interations/second converting       numeric => smallint.
 1480330 interations/second converting       numeric => int.
 1490035 interations/second converting       numeric => tinyint.
 3482255 interations/second converting       numeric => image.
 3512098 interations/second converting       numeric => binary.
11170040 interations/second converting       numeric => decimal.
13314668 interations/second converting       numeric => bit.
$ cat out.txt | grep '=> numeric' | grep interations | sort -n
   22250 interations/second converting         money => numeric.
  383822 interations/second converting         float => numeric.
  389949 interations/second converting          real => numeric.
  492343 interations/second converting    smallmoney => numeric.
  499212 interations/second converting         image => numeric.
  509305 interations/second converting        binary => numeric.
  593320 interations/second converting      smallint => numeric.
  598152 interations/second converting       tinyint => numeric.
  598671 interations/second converting     long long => numeric.
  619851 interations/second converting           int => numeric.
  830730 interations/second converting          char => numeric.
  833455 interations/second converting       varchar => numeric.
  833563 interations/second converting          text => numeric.
 1062558 interations/second converting           bit => numeric.
11183816 interations/second converting       decimal => numeric.

freddy77