34
Load table from SQLServer: ASPX data sets con’t
loOleDA=new System.Data.OleDb.OleDbDataAdapter( _
l  "SELECT "+cFields+" WHERE Appointment_Notes IS NOT NULL", _
l  oOleDB)
loSqlDA=new System.Data.SqlClient.SqlDataAdapter( _
l  "SELECT "+cFields+" WHERE Appointment_Notes IS NOT NULL", _
l  oSqlClient)
lResponse.Write("Created data adapters "+CSTR(TIMER-nStart)+"<br>")
loOleDA.Fill(oDS,"History")
lResponse.Write("Loaded dataset table "+CSTR(TIMER-nStart)+"<br>")
loDS.Clear()
lnStart=TIMER
loSqlDA.Fill(oDS,"History")
lResponse.Write("Loaded dataset table "+CSTR(TIMER-nStart)+"<br>")
loRows=oDS.Tables("History").Rows
lResponse.Write("Done "+CSTR(TIMER-nStart)+" "+CSTR(oRows.Count)+"<br>")
l
l'must close explicitly or subsequent page access will be slow (because of delayed
l'garbage collection??)
loOleDB.Close()
loSqlClient.Close()
loDS.Clear()
l%>
l
lOn 850 MHz PIII: First cFields list gives (OleDB) .25s, (SQLClient) .18s [compare ASP at .25s]
lSecond cFields list gives (OleDB) 1.7s, (SQLClient) .88s [compare asp at .70s]
l