title: Slow in filling .NET DataSet from Oracle 9i
body: <p>This is a problem that my friend asked over the phone. The C# 3.5 program he has written is filling a Dataset from a Patient Master table which has 350,000 records. It uses the Microsoft ADO.NET driver for Oracle. The ExecuteQuery method takes over 30 seconds to fill the dataset. However, the same query (fetching about 20K records) takes less than 3 second in Toad . He is not using any Transactions within the program. It has an index on the column (Name) which is being used to search.</p>
  
  <p>These are some alternatives i suggested :-</p>
  
  <p>1) Try to use a Data Reader and then populate a Data table and pass it to the form to bind it to the Combo box (which is not a good idea since it is likely to take same time)</p>
  
  <p>2) Try Oracles' ADO.NET Driver </p>
  
  <p>3) Use Ants profiler to see if you can identify any particular ADO.NET line.</p>
  
  <p>Has anyone faced similar problems and what are some ways of resolving this.</p>
  
  <p>Thanks,
  Chak.</p>