Re: [Firebird-net-provider] slow FbDataReader

[<vsn...@pr...>]

>> Data access with FbDataReader is more slower than access with Delphi-BDE
or
>> IBO Objects.
>> Actually fatch times are twice slower.
>> What do you think about it ? Have you a similar experience ?

>Can you explain what type of tests you have done ??


I purposly uses * , not column enumeration becouse I want to fetch all data
for this test.
If I use similar data access with Delphi's TQuery object, fetch-time is
twice faster.
So I don't know if slower access is FbDataReader attribute or I should use
another way to fetch all data from table.


string sql = "SELECT * FROM TABLE";
FbConnection myConnection = new FbConnection(connectionString);
FbCommand myCommand = new FbCommand(sql,myConnection);
myConnection.Open();
FbDataReader myReader = myCommand.ExecuteReader();
int i = 0;
while(myReader.Read())
{
      Console.WriteLine("{1} {0}",myReader.GetString(0),i++);
}
myReader.Close();
myConnection.Close();

thanks