Re: [Firebird-net-provider] Slowdown with MissingSchemaAction.AddWithKey

[<car...@te...>]

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.