Måling af hastihed: ODBC vs. oledb

lytter lige med her..

Fik udarbejdet dette C# eksempel med ODBC.NET driver. Håber du kan bruge det.

protected void Page_Load(Object sender, EventArgs e)
{
DateTime StartTime = DateTime.Now;

string mySQLConnStr = "driver={MySQL ODBC 3.51 Driver};";
mySQLConnStr = mySQLConnStr + "server=localhost;";
mySQLConnStr = mySQLConnStr + "Option=131072;";
mySQLConnStr = mySQLConnStr + "uid=root;";
mySQLConnStr = mySQLConnStr + "pwd=;";
mySQLConnStr = mySQLConnStr + "database=test;";

OdbcConnection myConnection = new OdbcConnection(mySQLConnStr);

string SQL = "select * from testTable";
OdbcDataAdapter myCommand = new OdbcDataAdapter(SQL,myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "testTable");
MyDataGrid.DataSource=ds.Tables["testTable"].DefaultView;
MyDataGrid.DataBind();

DateTime StopTime = DateTime.Now;
TimeSpan ElapsedTime = StopTime - StartTime;
string subHead = ElapsedTime.ToString();
string head = "<center><h2>Udtræk fra mySQL database med ODBC.NET driver</h2>";
subHead = "Forespørgslen tog <strong>" + subHead.Substring(6, 10) + "</strong> sekunder.</center>";
Response.Write(head);
Response.Write(subHead);
}