Speed issue

[Jakub Scheibe <ja...@gmail.com>]

Hi,

Let's say that I have simple class with 10 properties:

Class1:
   Attrib1
   .
   .
   .
   Attrib10

I have around 30.000 records in my table.

If I will execute select * from table1 using:

            OdbcConnection odbccon = new OdbcConnection();
            odbccon.ConnectionString = "DRIVER={Firebird/InterBase(r)
driver};Dialect=3;PASSWORD=pass;UID=USER;DBNAME=localhost:c:\\db.GDB";

            OdbcCommand command = new OdbcCommand("select * from table1",
odbccon);

            odbccon.Open();

            OdbcDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}",
reader[1], reader[2], reader[3], reader[4], reader[5], reader[6], reader[7],
reader[8], reader[9], reader[10]);
            }

            reader.Close();

It will take around 40s to display all the results, but If I will use iBatis
and call same query with it, it will take 934s.
Any ideas why??

I'm working on Firebird DB using Firebird ODBC drivers.

Regards,
Jakub.