Skip to Content.
Sympa Menu

freetds - Re: [freetds] bit day

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] bit day
  • Date: Mon, 3 Mar 2003 23:52:49 -0500

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



  • [freetds] bit day, Frediano Ziglio, 03/02/2003
    • Re: [freetds] bit day, James K. Lowden, 03/03/2003

Archive powered by MHonArc 2.6.24.

Top of Page