Excutereader is very slow when taking data by oledbcommand object <p>I am fetching data from dBase4 database by using object of oledbcommand and load it into datatable. but it is taking too much time to fetch 160 records around 5-10 minutes. Please Help me Out.</p> <p>Code:</p> <pre><code> using (OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + TrendFilePath + "\\" + Pathname + ";" + @"Extended Properties=dBASE III;")) using (OleDbCommand cm = cn.CreateCommand()) { cn.Open(); for (int L = 0; L &lt;= months; L++) { DataTable dt_Dbf = new DataTable(); From_Date = DateTime.ParseExact(frmdate, dateFormat2, provider); From_Date = From_Date.AddMonths(L); int month = From_Date.Month; string year = "1" + From_Date.Year.ToString().Substring(2, 2); if (L == 0) { cm.CommandText = @"SELECT * FROM 128.DBF where DATE_Y =" + year + " and DATE_M = " + month + " and DATE_D&gt;=" + From_Day + ""; dt_Dbf.Load(cm.ExecuteReader(CommandBehavior.CloseConnection)); } } } </code></pre>