ebryn

ejb-mbp2:Gauge ebryn$ bundle config
Settings are listed in order of priority. The top value will be used.

disable_shared_gems
  Set for your local app (/Users/ebryn/Dev/Gauge/.bundle/config): "1"

path
  Set via BUNDLE_PATH: "/Users/ebryn/.rvm/gems/rbx-head"

ebryn

ejb-mbp2:~ ebryn$ gem env
RubyGems Environment:
  - RUBYGEMS VERSION: 1.3.7
  - RUBY VERSION: 1.8.7 (2010-09-23 patchlevel 174) [x86_64-apple-darwin10.4.0]
  - INSTALLATION DIRECTORY: /Users/ebryn/.rvm/gems/rbx-head
  - RUBYGEMS PREFIX: /Users/ebryn/.rvm/rubies/rbx-head
  - RUBY EXECUTABLE: /Users/ebryn/.rvm/rubies/rbx-head/bin/rbx
  - EXECUTABLE DIRECTORY: /Users/ebryn/.rvm/gems/rbx-head/bin
  - RUBYGEMS PLATFORMS:
    - ruby

ebryn

ejb-mbp2:~ ebryn$ gem env
RubyGems Environment:
  - RUBYGEMS VERSION: 1.3.7
  - RUBY VERSION: 1.8.7 (2010-09-23 patchlevel 174) [x86_64-apple-darwin10.4.0]
  - INSTALLATION DIRECTORY: /Users/ebryn/.rvm/gems/rbx-head
  - RUBYGEMS PREFIX: /Users/ebryn/.rvm/rubies/rbx-head
  - RUBY EXECUTABLE: /Users/ebryn/.rvm/rubies/rbx-head/bin/rbx
  - EXECUTABLE DIRECTORY: /Users/ebryn/.rvm/gems/rbx-head/bin
  - RUBYGEMS PLATFORMS:
    - ruby

ebryn

require 'rubygems'
require 'bench_press'
# begin gem 'odbc', '0.99992' ; rescue Gem::LoadError ; end
require 'odbc'
$:.unshift File.expand_path('../../../lib',__FILE__)
require 'tiny_tds'

extend BenchPress

author 'Erik Bryn'

ebryn

diff --git a/ext/tiny_tds/result.c b/ext/tiny_tds/result.c
index 1aef319..8ac897c 100644
--- a/ext/tiny_tds/result.c
+++ b/ext/tiny_tds/result.c
@@ -164,12 +164,16 @@ static VALUE rb_tinytds_result_fetch_row(VALUE self, ID timezone, int symbolize_
             if (year < 1902 || year+month+day > 2058) {
               VALUE datetime_sec = INT2NUM(sec);
               if (msec != 0) {
-                #ifdef HAVE_RUBY_ENCODING_H
-                  VALUE rational_msec = rb_Rational2(INT2NUM(msec*1000), opt_onemil);

ebryn

diff --git a/ext/tiny_tds/result.c b/ext/tiny_tds/result.c
index 307a2c1..24cbb23 100644
--- a/ext/tiny_tds/result.c
+++ b/ext/tiny_tds/result.c
@@ -285,12 +285,23 @@ static VALUE rb_tinytds_result_each(int argc, VALUE * argv, VALUE self) {
           if (rwrap->number_of_results == 0) {
             rwrap->results = result;
           } else if (rwrap->number_of_results == 1) {
-            VALUE multi_resultsets = rb_ary_new();
-            rb_ary_store(multi_resultsets, 0, rwrap->results);

ebryn

> @client.execute("SELECT 1 AS [rs1];\nSELECT 2 AS [rs2]").each.inspect
=> [[{"rs1" => 1}], [{"rs2" => 2}]]

ebryn

ejb-mbp2:activerecord-sqlserver-adapter ebryn$ ruby test/benchmark/query_sqlserver.rb 
-- create_table(:test_benchmarks, {:force=>true})
   -> 0.0715s
Query Sqlserver
===============
Author: Erik Bryn  
Date: October 19, 2010  
Summary: Benchmark SQL Server Queries  

System Information

ebryn

diff --git a/ext/tiny_tds/result.c b/ext/tiny_tds/result.c
index 7d9f0fa..91f951b 100644
--- a/ext/tiny_tds/result.c
+++ b/ext/tiny_tds/result.c
@@ -157,8 +157,12 @@ static VALUE rb_tinytds_result_fetch_row(VALUE self, ID timezone, int symbolize_
           val = ENCODED_STR_NEW2(converted_unique);
           break;
         }
-        case SYBDATETIME4:
-          dbconvert(rwrap->client, coltype, data, data_len, SYBDATETIME, data, data_len);

ebryn

diff --git a/ext/tiny_tds/client.c b/ext/tiny_tds/client.c
index 70796b2..aa16c6a 100644
--- a/ext/tiny_tds/client.c
+++ b/ext/tiny_tds/client.c
@@ -88,7 +88,7 @@ static VALUE allocate(VALUE klass) {
 
 static VALUE rb_tinytds_tds_version(VALUE self) {
   GET_CLIENT_WRAPPER(self);
-  return INT2FIX(dbtds(cwrap->client));
+  return INT2FIX(8);