Hi,
Since you are saying both the files are around 4 MB, but one has 10000 elements whereas second has 1500 elements, I assume, the structure is different which might be causing multiple table reading.
You may like to try calling BeginLoadData before calling ReadXml method.
foreach (DataTable dataTable in dataSet.Tables)
dataTable.BeginLoadData();
dataSet.ReadXml("file.xml");
foreach (DataTable dataTable in dataSet.Tables)
dataTable.EndLoadData();
More details and source of the above code is MSDN at
http://msdn.microsoft.com/en-us/library/fx29c3yd.aspx[
^]
Hope that helps
- Milind