Hello:
> Are you seeing the same kind of results. Is there anything that can be done
> to speed up this process?
I get good times, but i´m not sure if i´m making the correct test, i´m
making this:
FbConnection connection = new FbConnection(connectionString);
connection.Open();
FbTransaction transaction = connection.BeginTransaction();
FbCommand command = new FbCommand("select * from EMPLOYEE",
connection, transaction);
FbDataAdapter adapter = new FbDataAdapter(command);
FbCommandBuilder builder = new FbCommandBuilder(adapter);
DataSet ds1 = new DataSet();
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.Fill(ds1, "EMPLOYEE");
adapter.Dispose();
builder.Dispose();
command.Dispose();
connection.Close();
With this MissingSchemaAction set to MissingSchemaAction.AddWithKey
FbDataReader.GetScemaTable will be called and without it not, this is
the only difference that i found.
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.
|
