T
Tomislav Stilinoviæ
Hi all,
I have a question about performance of OleDbCommand with command
parameters. I try to get records from table with 1500000 records in two
ways,
with command parameters (a) and without them (b). Field type is char and it
also has index. Option (a) gives me result in 30 seconds and option
(b) in 0.15 seconds. With SqlCommand results are the equal.
Any ideas?
Dim t As New DataTable
Dim cmd As New OleDbCommand
Dim cnn As new OleDbConnection(".....")
Dim rdr As oledbDataReader
(a)
cnn.open()
cmd.connection=cnn
cmd.CommandText = "SELECT * FROM Table WHERE Field >= ? AND Field <= ?"
cmd.Parameters.Add("P1", "Value1")
cms.Parameters.Add("P2", "Value2")
rdr=cmd.ExecuteReader
(b)
cnn.open()
cmd.connection=cnn
cmd.CommandText = "SELECT * FROM Table WHERE Field >= 'Value1' AND Field <=
'Value2'"
rdr=cmd.ExecuteReader
Thanx in advance.
Tomislav
I have a question about performance of OleDbCommand with command
parameters. I try to get records from table with 1500000 records in two
ways,
with command parameters (a) and without them (b). Field type is char and it
also has index. Option (a) gives me result in 30 seconds and option
(b) in 0.15 seconds. With SqlCommand results are the equal.
Any ideas?
Dim t As New DataTable
Dim cmd As New OleDbCommand
Dim cnn As new OleDbConnection(".....")
Dim rdr As oledbDataReader
(a)
cnn.open()
cmd.connection=cnn
cmd.CommandText = "SELECT * FROM Table WHERE Field >= ? AND Field <= ?"
cmd.Parameters.Add("P1", "Value1")
cms.Parameters.Add("P2", "Value2")
rdr=cmd.ExecuteReader
(b)
cnn.open()
cmd.connection=cnn
cmd.CommandText = "SELECT * FROM Table WHERE Field >= 'Value1' AND Field <=
'Value2'"
rdr=cmd.ExecuteReader
Thanx in advance.
Tomislav