DateTime vs Time TinyTds Benchmark

gistfile1.txt

# Always use DateTime https://github.com/lsylvester/tiny_tds/tree/all_datetimes

Query Tinytds
=============
Author: Ken Collins  
Date: September 14, 2011  
Summary: Benchmark TinyTds Querys  

System Information
------------------
    Operating System:    Mac OS X 10.7.1 (11B26)
    CPU:                 Intel Core i7 2.66 GHz
    Processor Count:     2
    Memory:              8 GB
    ruby 1.8.7 (2011-06-30 patchlevel 352) [i686-darwin11.1.0]

"Nothing" is up to 89% faster over 1,000 repetitions
----------------------------------------------------

    Nothing     0.256383895874023 secs    Fastest
    Guids       0.363122940063477 secs    29% Slower
    Bits        0.371165990829468 secs    30% Slower
    Floats      0.387125968933105 secs    33% Slower
    Moneys      0.427673101425171 secs    40% Slower
    Binaries    0.461602210998535 secs    44% Slower
    Integers    0.482095956802368 secs    46% Slower
    Decimals    0.525987148284912 secs    51% Slower
    Chars       0.603652954101562 secs    57% Slower
    Dates       0.896919965744019 secs    71% Slower
    All         2.35087704658508  secs    89% Slower
    
# Always use Time https://github.com/lsylvester/tiny_tds/tree/all_times

Query Tinytds
=============
Author: Ken Collins  
Date: September 14, 2011  
Summary: Benchmark TinyTds Querys  

System Information
------------------
    Operating System:    Mac OS X 10.7.1 (11B26)
    CPU:                 Intel Core i7 2.66 GHz
    Processor Count:     2
    Memory:              8 GB
    ruby 1.8.7 (2011-06-30 patchlevel 352) [i686-darwin11.1.0]

"Nothing" is up to 90% faster over 1,000 repetitions
----------------------------------------------------

    Nothing     0.2619309425354   secs    Fastest
    Guids       0.331676006317139 secs    21% Slower
    Bits        0.368582010269165 secs    28% Slower
    Floats      0.399556875228882 secs    34% Slower
    Moneys      0.437234163284302 secs    40% Slower
    Integers    0.485384941101074 secs    46% Slower
    Binaries    0.498826026916504 secs    47% Slower
    Decimals    0.509860992431641 secs    48% Slower
    Chars       0.721299171447754 secs    63% Slower
    Dates       1.29904913902283  secs    79% Slower
    All         2.85737800598145  secs    90% Slower