I am seeing vastly different SQL performance numbers in a ported J# project
vs. my old J++ code base.  The problem seems to be ResultSet.getString() --
.getInteger() performs just fine.  I saw some posts about setting
sendStringParametersAsUnicode=false but that did not help in my case.

Here are the results of a test against the standard SQL Server Northwind
database:
--------------------------------------------------
J#
execute query took - 0.094 seconds
processing result set took - 0.75 seconds

J++
execute query took - 0.016 seconds
processing result set took - 0.078 seconds
---------------------------------------------------

My (very simple) test case is below.  It goes against the Northwind database
so it is easy to try out, and it compiles as is in both J# and J++.  Am I
missing a config parameter or something?

Thanks,
-B

package UnitTests;

import java.sql.*;
import java.util.*;

/**
* Summary description for DBPerformanceTest.
*/
public class DBPerformanceTest
{
    public static final String sql = "select EmployeeID, ShipName, ShipAddress
from Orders";

    private Connection connection = null;

    public static void main(String[] args)
    {
        try
        {
            DBPerformanceTest test = new DBPerformanceTest();
            test.Init();
            test.runPerformanceTest();
            Thread.sleep(10000);
        }
        catch(Throwable e)
        {
            e.printStackTrace();
        }
        System.exit(0);
    }

    public DBPerformanceTest()
    {
    }

    public void Init() throws Exception
    {
        synchronized(this)
        {
            if(connection == null)
            {
                Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
                String url = "jdbc:odbc:Driver={SQL
Server};Server=(local);UID=sa;PWD=;Database=northwind;sendStringParametersAsUnicode=false";
                Properties p = new Properties();
                p.put("selectMethod", "cursor");
                connection = DriverManager.getConnection(url, p);
                connection.setAutoCommit(false);
                connection.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
   
            }
        }
    }

    public void runPerformanceTest() throws Exception
    {
        this.getInfoViaJDBC();
    }

    public void getInfoViaJDBC() throws Exception
    {
        Timer timer;
        double javaTime;
        String message;

        timer = new Timer();
        timer.start();
        Statement st = connection.createStatement();
        ResultSet r = st.executeQuery(sql);
        timer.stop();
        javaTime = timer.value();

        message = "execute query took - "+javaTime+" seconds";
        System.out.println(message);

        timer = new Timer();
        timer.start();
        while (r.next())
        {
             Integer i = new Integer(r.getInt(1));
             String s1 = r.getString(2);
             String s2 = r.getString(3);
        }

        r.close();
        st.close();
        timer.stop();
        javaTime = timer.value();
        message = "processing result set took - "+javaTime+" seconds";
        System.out.println(message);
    }
}

------------------------------------------------
Timer class
-------------------------------------------------

package UnitTests;

import java.io.PrintWriter;
import java.text.*;

public class Timer
{
   static String id = "@(#) $Id: Timer.java,v 1.2 2002/12/27 20:37:48 hook
Exp $";

    private long begin;
    private long end;
    DecimalFormat df;

    public Timer()
    {
        super();
        begin = 0;
        end = 0;
        df = new DecimalFormat("00.##");
    }

    long now()
    {
        return System.currentTimeMillis();
    }
    public void start()
    {
        begin = now();
    }

    public void stop()
    {
        end = now();
    }

    public double value()
    {
        return ((end - begin)/1000.000);
    }

    public String toString()
    {
        double secs = this.value();
        double mins = Math.floor(secs / 60.0);
        double hours = Math.floor(mins / 60.0);
        secs = secs - (60.0 * mins);
        mins = mins - (60.0 * hours);
        return (df.format(hours) + ":" + df.format(mins) + ":" + df.format(secs));
    }
    public void print()
    {
        System.out.println(toString());
    }
    public void print(PrintWriter writer)
    {
        writer.println(toString());
    }

}