Speed up Performace on large amount of data

[AndyR]

Hi,

i use following code to fill a datatable:

Code: Select all

 
public static DataTable SelectAusfuehren(String istatement)
        {
           var comm = new OracleCommand { Connection = UserConnection.getConnection() };
           comm.CommandText = istatement;
           var dt = new DataTable();
           var da = new OracleDataAdapter(comm);
           da.Fill(dt);
           return dt;
        }

Now 2 million Rows with 12 colums are returned by my select an it needs about 36 seconds.
I already used the search of the forum but i was not able to find anything.
So, i there anything i can do to speed up the performance (properties etc). I need all colums and rows.

Thank you very much!
Andy

[Shalex]

We recommend you to employ OracleDataReader - it retrieves data from the database faster and consumes less memory: http://www.devart.com/dotconnect/oracle ... eader.html.
If you need to use OracleDataTable, try changing the FetchSize property value of the OracleCommand object of your OracleDataTable and checking the results: http://www.devart.com/dotconnect/oracle ... hSize.html.