Skip to Content.
Sympa Menu

freetds - [freetds] bit day

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS <freetds AT lists.ibiblio.org>
  • Subject: [freetds] bit day
  • Date: 02 Mar 2003 22:01:37 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page